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.

Sort records by multiple date fields

Topic Labels: Automations
1783 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Kat_Dalager
5 - Automation Enthusiast
5 - Automation Enthusiast

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!