cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Formula to filter to only rows with date older than x?

Highlighted
Asteroid

I'm sure this is a simple formula, just not familiar with writing them in Alteryx yet.

 

I'm looking to create a workflow on a schedule to automatically back up records from a sharepoint list that are over XX days old.   I'll filter to those and backup to an excel sheet.

 

Appreciate any assistance!

Bolide

Hi @Shap

 

You can try this formula to get the number of days old:

 

DateTimeDiff(DateTimeToday(),[Record Date],"days")

 

If that's not enough to solve your question, please post more details. Let us know if this works!