Report Troubleshooting (Excel Date Fields)

StrataMax stores a 4-digit year code in the date field, which is available in many of the software's areas. When completing the data entry for a date field in any of these areas, for example, Certificates, Inspections, and Contracts, Windows determines the first two digits based on what is set via the administrative area.  A format that supports this is recommended. The Windows article below will assist in checking and setting this format where required.

https://support.microsoft.com/en-au/office/change-the-date-system-format-or-two-digit-year-interpretation-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f