
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 02:30 PM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 02:37 PM
Hi @Kat_Dalager
Maybe try this (edit updated for earliest date):
IF({Date 1}<{Date 2}, {Date 1}, {Date 2})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 02:42 PM
Thanks, I’ll try it!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 02:48 PM
It seems to be taking the earliest date and subtracting a day. Any idea what I did wrong?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 02:53 PM
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!
