Date-time values for Maintain may be supplied in one of the following ways:

• As a value in a computed expression, enclosed in double or single quotes.
• As a value extracted or computed by a date-time function.
• Using an application Winform.

Maintain supports the date-time data type with the following restrictions:

• The default date-time format separators (/) must be used. Other separators are not supported.
• When you create a WHERE statement or an IF THEN ELSE clause, you must use a variable as the test value.
• The format SET DATEFORMAT, used to change the default input format, is not supported.
• The SET commands WEEKFIRST and DTSTRICT are not supported.
• Computing an expression to DT (value) is not supported.

A date-time constant in a Maintain procedure, and in an IF expression in a report procedure, has one of the following formats (note that in a report procedure's IF expression, if the value contains no blanks or special characters, the single quotation marks are not necessary)

'date_string  [time_string]'
'time_string  [date_string]'

where:

time_string

Cannot contain blanks. Time components are separated by colons and may be followed by AM, PM, am, or pm. For example:

14:30:20:99       (99 milliseconds)
14:30
14:30:20.99       (99/100 seconds)
14:30:20.999999   (999999 microseconds)
02:30:20:500pm

Note that seconds can be expressed with a decimal point or be followed by a colon.

• If there is a colon after seconds, the value following it represents milliseconds. There is no way to express microseconds using this notation.
• A decimal point in the seconds value indicates the decimal fraction of a second. Microseconds can be represented using six decimal digits.

date_string

Can have one of the following three formats:

• The numeric string format is exactly four, six, or eight digits. Four-digit strings are considered to be a year (century must be specified); the month and day are set to January 1. Six and eight-digit strings contain two or four digits for the year, followed by two for the month, and then two for the day.

  If a numeric-string format longer than eight digits is encountered, it is treated as a combined date-time string in the Hnn format described in the Describing Data manual. The following are examples of numeric string date constants:

  99
  1999
  19990201

• The formatted-string format contains a one or two-digit day, a one or two-digit month, and a two or four-digit year separated by spaces, slashes, hyphens, or periods. If any of the three fields is four digits, it is interpreted as the year, and the other two fields must follow the order given by the DATEFORMAT setting. The following are examples of formatted-string date constants:

  1999/05/20
  5 20 1999
  99.05.20
  1999-05-20

• The translated-string format contains the full or abbreviated month name. The year must also be present in four-digit or two-digit form. If the day is missing, day 1 of the month is assumed; if present, it can have one or two digits. If the string contains both a two-digit year and a two-digit day, they must be in the order given by the DATEFORMAT setting. For example:

  January 6 2000

Note:

• The date and time strings must be separated by at least one blank space. Blank spaces are also permitted at the beginning and end of the date-time string.
• In each date format, two-digit years are interpreted using the [F]DEFCENT and [F]YRTHRESH settings.

COMPUTE RAISETIME/HYYMDIA = '20000101 09:00AM'; 

date_time_field {GT|GE} date_time_value AND date_time_field NE MISSING

FILE=DATETIM2,  SUFFIX=FOC                ,$
SEGNAME=DATETIME, SEGTYPE=S0              ,$
FIELD=ID, ID, USAGE = I2                  ,$
FIELD=DT1, DT1,   USAGE=HYYMDS, MISSING=ON,$

TABLE FILE DATETIM2
PRINT ID DT1
END

ID  DT1
--  ---
 1  2000/01/01 02:57:25
 2  1999/12/31 00:00:00
 3  .

TABLE FILE DATETIM2
PRINT ID DT1
  WHERE DT1 NE MISSING AND DT1 GT DT(2000/01/01 00:00:00);
END

ID  DT1
--  ---
 1  2000/01/01 02:57:25