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-windows-regional-settings-to-modify-the-appearance-of-some-data-types-in-access-databases-edf41006-f6e2-4360-bc1b-30e9e8a54989