DATETIMESUB - Subtract specified amount from the date time variable

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