Modify the date and number format

Date and time formats

The default date and time formats are:

  English French
Date mm/dd/yy dd/mm/yy
Time HH:mm:ss HH:mm:ss

Modify date and/or time format

  1. Go to Designer > Dictionaries and add a new dictionary called datastore if it does not exist.
    • For date format, add / modify the format.js.date key, add a value for each language
    • For time format, add / modify the format.js.time key, add a value for each language
  2. Deploy the Dictionaries to the admin application.
  3. Logout and login again in Datastore Client.

More details:

For details on date formatters, see jQuery UI Datepicker formats at:

http://api.jqueryui.com/datepicker/#utility-formatDate

Number formats and export separators

The default number formats and export separators are:

  English French
Decimal separator . ,
Thousands separator , \u0020 (space)
CSV separator , ;
CSV decimal separator . ,

Modify number format and/or export separators

  1. Go to Designer > Dictionaries and add a new dictionary called datastore if it does not exist.
    • For decimal separator, add / modify the format.js.separator.decimal key, add a value for each language
    • For thousands separator, add / modify the format.js.separator.thousand key, add a value for each language
    • For CSV separator, add / modify the format.csv.separator key, add a value for each language
    • For CSV decimal separator, add / modify the format.csv.numberFormat.decimal.separator key, add a value for each language
  2. Deploy the Dictionaries to the admin application.
  3. Log out and log in again in Datastore Client.

Related Links