Sep 19, 2023 03:23 PM
I cannot decide if I'm better off with an automation or else I'm just not meant to do if else formulas. I need to first check if a date field is not blank. If it is not blank, then I want to compare it with another date field. If it's later than other date field I want to show 'launch date moved out'. I know this formula is not comparing but it's what I ended up with (and it's not working)
IF({Original Launch Date} & "-"
THEN {Launch Date}>{Original Launch Date},'Launch Delayed')
Solved! Go to Solution.
Sep 19, 2023 08:16 PM
Hi,
the correct syntax should be something like:
IF({Original Launch Date},
IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))
Sep 22, 2023 06:31 AM
Sep 19, 2023 05:12 PM
Now that I've had a moment to reflect, my question is actually:
IF({Launch Date}>{Original Launch Date} & {Original Launch Date} & "-" & },'Launch Delayed')
I want to compare two dates only if one of the dates field is not blank
Sep 19, 2023 08:16 PM
Hi,
the correct syntax should be something like:
IF({Original Launch Date},
IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))
Sep 22, 2023 06:31 AM
Perfect! thank you!