Moving Date Range

[GiantPencil]

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

[RodL · Accepted solution]

Try this...

DateTimeAdd(DateTimeToday(),-21,'days') > [Date]

[GiantPencil]

worked a treat, thanks!!