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.

  5. Click Save.
  6. 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