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

Sort records by multiple date fields

Topic Labels: Automations
176 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I need help writing a script or formula that will allow me to sort records by the earliest date of two date fields. I’m trying to avoid having to create a third date field. Thanks!

4 Replies 4

Hi @Kat_Dalager
Maybe try this (edit updated for earliest date):

IF({Date 1}<{Date 2}, {Date 1}, {Date 2})

image

Thanks, I’ll try it!

It seems to be taking the earliest date and subtracting a day. Any idea what I did wrong?

I think I know what I did. I clicked off the “same time zone for all collaborators.” I clicked it back on and it worked. Thank you!