Skip to main content

Setting Date Formats

Written by Stephen Krzeminski

If you want to change the date format used across the platform, such as changing to MM/DD/YYYY from YYYY/MM/DD, click on the Settings button, then on System Configuration.

Navigate to the Settings tab and enable Custom Date & Time Format. Use the drop-down menus to choose the Time Format (12 vs. 24-hour time), Date Order (order of month, date, year), and Date Display Style (Aug vs. August, numeric, etc.).

Changing this setting will affect the way dates are displayed in your platform, such as in the Learners tab of your courses, in reports, and in any CSVs you download, and will also be shown in Certificates using the following placeholders:

Time stamp included (e.g. 2:30 pm)

[NICE_COMMENCEMENT_DATE_WITH_TIME]
[NICE_ENROLLMENT_DATE_WITH_TIME]
[NICE_COMPLETION_DATE_WITH_TIME]
[NICE_EXPIRATION_DATE_WITH_TIME]
[NICE_CURRENT_EXPIRATION_DATE_WITH_TIME]
[NICE_COURSE_START_DATE_WITH_TIME]
[NICE_COURSE_END_DATE_WITH_TIME]
[NICE_ACCESS_START_DATE_WITH_TIME]
[NICE_ACCESS_END_DATE_WITH_TIME]

Date only:

[NICE_COMMENCEMENT_DATE] 
[NICE_ENROLLMENT_DATE]
[NICE_COMPLETION_DATE]
[NICE_EXPIRATION_DATE]
[NICE_CURRENT_EXPIRATION_DATE]
[NICE_COURSE_START_DATE]
[NICE_COURSE_END_DATE]
[NICE_ACCESS_START_DATE]
[NICE_ACCESS_END_DATE]

CSV Notes:

While CSVs will be downloaded with your selected date format, some software, such as Excel, will automatically format the dates in the file and they may not appear to match.

Additionally, when using text for months in CSVs, such as August 10, 2026 or Aug 10, 2026 instead of numbers like 08/10/2026, the platform will automatically read and input the correct date, regardless of the configuration chosen and the order the text.

Numeric formats other than the platform default of yyyy-mm-dd will always be imported according to the Custom Date & Time Format selected in your platform.

Did this answer your question?