Hi All,
Just started using Alteryx and I'm trying to put in a filter to my data source that look will give me projects that are older than 3 weeks.
Basically........ [Week Ending] > projects older than 3 weeks - this is where I'm struggling. I think it may involve the functions DateTimeDiff(dt1,dt2,u) and DateTimeNow() just can't get the combinations right.
Thanks for the help!
GP
Solved! Go to Solution.
Try this...
DateTimeAdd(DateTimeToday(),-21,'days') > [Date]
worked a treat, thanks!!