Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

maniruddha
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

1 REPLY 1
BrandonB
Alteryx
Alteryx

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

Labels