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!
Sort records by multiple date fields
+16Hi @Kat_Dalager
Maybe try this (edit updated for earliest date):
IF({Date 1}<{Date 2}, {Date 1}, {Date 2})
Hi @Kat_Dalager
Maybe try this (edit updated for earliest date):
IF({Date 1}<{Date 2}, {Date 1}, {Date 2})
Thanks, I’ll try it!
Hi @Kat_Dalager
Maybe try this (edit updated for earliest date):
IF({Date 1}<{Date 2}, {Date 1}, {Date 2})
It seems to be taking the earliest date and subtracting a day. Any idea what I did wrong?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.