Set Date, Time, and Decimal Formats

  • 1 minute(s) read
Prev Next

DMS  provides the ability to set the date, time, and decimal values in various format. This helps the users to view the values in their respective regional format. The date, time, and decimal values vary in formats from one region to another. Some regions may have more than one format too. Hence, the My Preference tab allows you to set the date, time, and decimal format based on your preference.

The following table lists the formats supported in the application:

Attribute Elements Description
Date •   MM/dd/yyyy
•   M/d/yyyy
•   d/M/yyyy
•   dd/MM/yyyy
•   dd-MM-yyyy
•   dd.MM.yyyy
•   yyyy/MM/dd
•   yyyy-M-d
•   yyyy-MM-dd		 •   06/03/2020
•   6/3/2020
•   3/6/2020
•   03/06/2020
•   03-06-2020
•   03.06.2020
•   2020/06/03
•   2020-6-3
•   2020-06-03
Time •   12-hour
•   24-hour		 •   10:30:15AM
•   22:30:15
Decimal Separator •   Decimal Comma (,)
•   Decimal Point (.)		 •   13,99
•   13.00
Notes:
  • If a user is unable to set the format in the application, then the fallback format is appended from the tenant level.
  • If the format is unavailable in the tenant, then the fallback format is appended from ecosystem.config file. The following are the default formats:
    • systemDefaultDateFormat : 'MM/dd/yyyy',
    • systemDefaultTimeFormat: 'hh:mm:ss',
    • systemDefaultDecimalSeparator: '.'
  • The application displays the number formats based on the selection of decimal separators in User Preferences.
  • When excel sheets are imported or exported from the application, the number formats reflecting in the sheets depend on the system regional settings irrespective of the settings in User Preferences. In case you find difference in the number format in the UI / excel sheet, you can change the format in the system regional settings.

To set date, time, and decimal formats:

  1. On the application header, click User Profile.

    Result: The User Preferences popup is displayed.

dms-user-profile1

  1. Click My Settings.

dms-my-settings1

Result: The My Preferences dialog box is displayed.

dms-my-pref

  1. Select the following:
  • Date Format - yyyy-M-d
  • Time format - 24-hour
  • Decimal Separator - Decimal Comma

dms-time-format

If you select 24 hour time format, then both AM and PM are not displayed in the Time Format dialog box.

dms-my-pref

  1. Click Save.

    Result: A confirmation message Data saved is displayed. Reload the application to view the changes.