Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF/OR statement to compare 2 sets of dates (4 fields total)

Topic Labels: Formulas
203 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to create a formula whereby :

IF [date 1] is after [date 2] OR [date 3] is after [date 4] to tell me “Needs Review”, otherwise “Updated”.

How do i do this? i’m not sure how to compare the date fields.

Thanks!

1 Reply 1
IF(
   OR(
      {Date 1} > {Date 2},
      {Date 3} > {Date 4}      
   ),
   "Needs Review",
   "Updated"
)