community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

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

Highlighted

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

Alteryx Certified Partner
Alteryx Certified Partner

How about trying something like this?

 

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

Chaos reigns within. Repent, reflect and reboot. Order shall return.

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

Labels