How do I convert Criteria1:="<=" & Date + 14 in Alteryx? I need past and +14 days

Marcegon

I need to select past dates and +14 days.  The formula below is giving me records taking place in (2) weeks only.  Could someone help?   

IF [Actual venue type] = "Virtual" THEN "Not required"
ELSEIF DATETIMEPARSE([Start_date], "%Y-%m-%d") >= DATETIMEADD(DATETIMENOW(), +14, "days") AND IsEmpty([Actual format]) THEN "0" Else [Actual format] ENDIF

johnyli168

Hey @Marcegon,

You could look to add another "AND" statement to catch the other side of the +/- days. 

I have attached an example with some dummy data.

date range formula.yxmd