Filtering data between "Today" and "Today-28" days

[maniruddha]

Hi,

I want to filter my DATE_UPDATED field to only carry results between today and today-28 days (Last 4 weeks).  In SQL I could write this as 

DATE_UPDATED between DATE-28 and DATE

How can I do the same in Alteryx?

Thanks

[bbak91 · Accepted solution]

[DATE_UPDATED] <= DateTimeNow() AND [DATE_UPDATED] >= DateTimeAdd(DateTimeNow(), -28, "days")