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?


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!


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!