Date/Time

External Formatting

When a date/time is presented externally (e.g. in myPass) the format of a date is dependent on the language being presented, but should always be displayed on a single line; the date cannot be separated onto multiple lines. This includes any prefixes considered to be part of the date (i.e. ‘le’).

English Formatting

When presented in English, the preferred format for a date/time is:

DD MMM YYYY hh:mm a.m./p.m.

Example:

  • 01 JAN 2001 10:01 a.m.
  • 14 JUN 2018 04:59 p.m.

French Formatting

When presented in French, the preferred format for a date/time is:

DD MMM YYYY 24 h [mm]

Where:

  • MMM is one of the following abbreviations:
    • 01 - janv.
    • 02 - févr.
    • 03 - mars
    • 04 - avr.
    • 05 - mai
    • 06 - juin
    • 07 - juill
    • 08 - aout
    • 09 - sept.
    • 10 - oct.
    • 11 - nov.
    • 12 - déc.
  • 24 is:
    • the hour from 0 to 23
    • does not include a leading 0 (e.g. 9 not 09)
  • [mm] is only included when not = 0 and includes zero padding (e.g. 09 not 9)

Examples:

When the time on the hour: 31 déc. 2001 15 h
When the time is not on the hour: 01 janv. 2001 9 h 01

Notes:

  • When presented by itself, the date/time value should always follow a 'le'. This includes:
    • When presenting a date/time in a separate column from the field label
    • When presenting a column of date/times where the column heading is the label
    • When presenting a date/time on a line of text by itself.

  • When a date/time is presented with other text, the 'le' (if required) will be incorporated appropriately into the text

Internal Formatting

When a date is presented internally (e.g. in PASIprep) the date should be formatted as:

YYYY-MM-DD hh:mm:ss am/pm