Date/Time Formatting

Depending on the context, DRT uses various date formats throughout the application.

Changes to these formats can be made in Administration > Settings > System:

  • Short Date Format: '%Y-%m-%d' (2017-05-01)
  • Long Date Format: '%b %e, %Y' (May 1, 2017)
  • Short DateTime Format: '%Y-%m-%d %H:%M:%S %Z' (2017-05-01 13:40:51 PDT)
  • Long DateTime Format: '%A, %B %e, %Y %l:%M %P %Z' (Monday, May 1, 2017 1:39 pm PDT)
  • Date Picker Format: ‘mm/dd/yyyy’ (05/01/2017)

This setting differs from the others as it only supports values of y, m & d. This defines the format of the popup calendar used throughout the application.

DRT uses date formatting variables as defined in PHP: http://php.net/manual/en/function.strftime.php

Date/time formatting within a report is solely defined by the report creator and independent of any application settings.