Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

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

Highlighted
7 - Meteor

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

Alteryx
Alteryx

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

Labels