Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

compare date fields only if first field is not blank

Topic Labels: Formulas
Solved
Jump to Solution
1175 3
cancel
Showing results for 
Search instead for 
Did you mean: 
airballer86
7 - App Architect
7 - App Architect

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')

 

2 Solutions

Accepted Solutions

Hi,
the correct syntax should be something like:

IF({Original Launch Date},
  IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))

 

See Solution in Thread

Perfect! thank you!

See Solution in Thread

3 Replies 3
airballer86
7 - App Architect
7 - App Architect

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

 

Hi,
the correct syntax should be something like:

IF({Original Launch Date},
  IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))

 

Perfect! thank you!