Defining the date/time format for iMIS

The Date Format field in the System Setup window is blank by default, which causes iMIS to use the U.S. English short date and time formats used in most U.S.-based computers. For example:

  • 11/16/2007 is the short date format that represents November 16, 2007
  • 2:16:26 PM is the time format that represents 14:16:26
📘

Note

Use a format that displays the entire four-digit year so that users can verify the correct century. iMIS typically assumes a year of 29 or less to refer to the 21st century (30/3/22 = 30 March 2022) and 30 or higher as the 20th century (30/3/30 = 30 March 1930).

Formatting date/time outside the United States

Whenever you have the operating system of an iMIS server set for a region other than U.S. English, be sure to specify a matching Date Format in iMIS. The region is set through Control Panel > Regional and Language Options, Regional Options.

For example, if the server specifies English (United Kingdom) for the regional language, 16/11/2007 for the Short date format, and 14:16:26 for the Time format, you must make iMIS match by specifying D/M/CY H:N:S in iMIS.

To define the date/time format for iMIS

  1. Log on to iMIS Desktop with the MANAGER logon.
  2. Choose File > System Setup.
  3. Click Edit.
  4. In the Date Format field, specify a combination of variables that represents the Short date and Time formats used by the operating system of the iMIS application server. Examples:
  • m D CY H:N.S.s returns "JUN 12 2008 15:45.00.00"
  • D m Y H:N A returns "12 JUN 08 3:45 PM"
  • M/D/Y H.N returns "06/12/08 15.45"
  • YMD returns "080612"

Refer to the table below for details.

  1. Click Save.
  2. Restart iMIS.
Variable Description Example
Y Year, 2-digit 99
y Year with Century, 4-digit 1999
C Century, 2-digit 19
M Month, numeric 06
m Month, 3-character abbr. In caps JUN
D Day of month, cardinal 12
d Day of month, ordinal 12th
W Day of week, numeric, Sunday=0, Saturday=6 5
w Day of week, full name Friday
H Hour of day, 24-hour format 0-23
h Hour of day, 12-hour format 1-12
N Minutes, 2-digit, with leading zero 07
S Seconds, 2-digit, with leading zero 02
s Hundredths of seconds, 2-digit 37
A AM/PM, all caps AM