Skip to content

Override Date Formats



Date Formats used throughout different parts of the world differs quite a bit. When formatting a report the selected locale typically controls how dates and numbers are formatted, the exception would be if a a date/number field of a report layout has been defined to use a hardcoded format and or formatted according to a hardcoded locale. In IFS Report Designer date fields can be formatted based on the runtime locale using either short, medium, long, or full date format. During formatting date values are then formatted accordingly based on standardized formatting rules. If the standard rules are not enough, they can be overridden using functionality available in IFS Cloud.

Override Date Formats in Runtime

This feature allows you to set date formats when in some locales the Standard format for short or medium defined in Report Formatter is not matching the generally used format in the locale.

The administrator can add new overrides from the Solution Manager tool. The installed languages are configured from the User Languages page under the Configuration folder. The sells under the columns Short Date, Medium Date, Long Date and Full Date will hold the relevant  override date format the for the corresponding language.

Date and Time format notation

y = year  M = month  d = day  h = hour m = minute  s =  second  t = am or pm

h = 12 hour

H = 24 hour

hh, mm, ss, MM, dd = leading zeros

h, m, s, M, d = no leading zeros

Note: This type of date formatting will only work in runtime.