Alteryx Designer Desktop Discussions

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

Moving Date Range - Filter To Include Projects Less Than 12 Weeks Old

GiantPencil
5 - Atom

Hi All,

 

Trying to filter a workflow I have that will only include projects that are less than 12 weeks. Have tried using this:

 

DateTimeAdd(DateTimeToday(),-84,'days')>DateTimeToday() 

 

The fields I have are below: 

Capture.JPG

 

Thanks for the help!

GP

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

How about trying something like this?

 

datetimediff(datetimetoday(),[DateField],"days") <= 84
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
GiantPencil
5 - Atom

This looks like it works anyway, the spot check I did gave me results within the last 12 weeks anyway. Thanks!

Labels