Date format display inconsistent

[Specify]

Hi @HeatherC (and @markp),

When double clicking, you shown the database date format configured for your Specify instance. Since you are in Canada , your browser shows you the mm/dd/yyyy date picker instead of the default American date format of dd/mm/yyyy.

You can configure what date format the WorkBench uses (and the format shown when double-clicking on a date field) by following this guide:

Configure Database Date Format

The database date format is determined by the Remote Prefs configuration in your database. This determines how Specify exports and handles dates nearly everywhere in both Specify 6 and 7. Date pickers within the application will be based on your browser’s locale (unless you disable ‘User accessible full date picker’ in the Specify 7 preferences. Data uploaded using the WorkBench will need to conform to the date format specified in the Remote Preferences file below. Go to the User Tools men…

This should resolve both of your issues! Keep in mind that older WorkBench data sets will need to be updated with the new date format in order to upload them after this change is made.