Custom date fields should export as dates, not text

In a nutshell, this idea is that all custom fields that are of DATE type need to export in a standard Excel date format and should not include ordinals (e.g., 1st should be 1, 2nd should be 2, 3rd should be 3, 4th should be 4.) With the current formatting of Sep 22nd, 2021, exported files cannot be sorted based on date.

As shown in the attached screenshot, a system field that is of date format exports into Excel as a date that can be sorted. A custom field does not. When sorted, it goes April, December, February, etc.

  • Joy Duling
  • Oct 9 2021
Category (Product Areas) Contacts
  • Attach files