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
Solved! Go to Solution.
[DATE_UPDATED] <= DateTimeNow() AND [DATE_UPDATED] >= DateTimeAdd(DateTimeNow(), -28, "days")