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
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.