# Date format display inconsistent

**URL:** <https://speciforum.org/t/date-format-display-inconsistent/1389>\
**Category:** Get Help\
**Created:** [November 2, 2023, 3:14pm UTC](https://speciforum.org/t/date-format-display-inconsistent/1389 "2023-11-02T15:14:14Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [November 2, 2023, 5:38pm UTC](https://speciforum.org/t/date-format-display-inconsistent/1389/4 "2023-11-02T17:38:06Z")

</div>

Hi @HeatherC (and @markp),

When double clicking, you shown the [database date format](https://speciforum.org/t/configure-database-date-format/1109) 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](https://speciforum.org/t/configure-database-date-format/1109):
>
> 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](https://speciforum.org/t/the-specify-7-workbench/540) will need to conform to the date format specified in the Remote Preferences file below. Go to the [User Tools](https://speciforum.org/t/user-tools-menu/536) 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.

---

_[View the full topic](https://speciforum.org/t/date-format-display-inconsistent/1389)._
