Help

compare date fields only if first field is not blank

Topic Labels: Formulas
Solved
Jump to Solution
1089 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!