DATETIMESUB        Subtract specified amount from the date time variable

Top  Previous  Next

Syntax:

DATETIMESUB

[ variable ] [ const ] [ /options ]

Arguments:

[ variable ]

A variable containing the formatted date and time string in the format of Sat Feb 17 11.00.22 2001.

 

[ const ]

A variable or a numeric constant representing the amount of time to subtract from the date and time string contained in [ variable ].

Options:

/day

Subtract specified number of days.

 

/hour

Subtract specified number of hours.

 

/minute

Subtract specified number of minutes.

 

/second

Subtract specified number of seconds.

 

 

This script command is used to subtract a specified amount of time from the formatted date and time string variable. The [ /options ] argument is required.

 

Note: The %datetime internal variable should not be passed directly in the [ variable ] argument of this command.  To use the value of %datetime with DATETIMESUB you must first assigned its value to to an intermediate user defined variable, and then pass that user defined variable as an argument.

 

Consider the example below where 14 days is subtracted from a variable containing the current date and time.

 

SET today = %datetime

DATETIMESUB today 14 /day

DISPLAY today

 

Consider the example below where 34 minutes is subtracted from a variable containing the current date and time.

 

SET today = %datetime

DATETIMESUB today 34 /minute

DISPLAY today

 

The number of days to subtract may also be expressed in a variable as shown below.

 

SET today = %datetime

SETNUM days = 14

DATETIMESUB today days /day

DISPLAY today

 

 

Related Command(s): DATETIMEADD, IFDATETIME, DATEADD, DATESUB, IFDATE

See also: Using the %date, %datetime, and %time Variables