Time Format for all Date Time and Time Fields (Application Setting)

All date time and time fields in the application will be affected by this setting unless they use the Specify a Time Format or Specify Alternate Time Format Field Settings. This setting will also be applied to the default reporting output for date time and time fields.

To build a new format simply type out the format that you would like to see using the special part markers where you want the different date parts to appear. For example a 12 hour time format would be {g}:{i} {a} and would output something like 3:36 pm.

Available Time Parts

  • AMPM Lowercase {a} - Lowercase Ante meridiem and Post meridiem, am or pm.
  • AMPM Upppercase {A} - Uppercase Ante meridiem and Post meridiem, AM or PM.
  • Hour {g} - 12-hour format of an hour without leading zeros, 1 through 12.
  • Hour 24 {G} - 24-hour format of an hour without leading zeros, 0 through 23.
  • Hour 24 with Leading Zero {H} - 24-hour format of an hour with leading zeros, 00 through 23.
  • Hour with Leading Zero {h} - 12-hour format of an hour with leading zeros, 01 through 12.
  • Minute {i} - Minutes with leading zeros, 00 through 59.
  • Second {s} - Seconds, with leading zeros, 00 through 59.
application setting - time format for all date time and time fields.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024