DateMath

 

 

 

DateMath

 

Description

Returns a new date (optionally formatted) with a specified number interval (signed integer) added to a specified date part of a specified date.

 

Arguments

1.DateMath - Name of the Macro.

2.Date Time String - A string representing the date time to use for the macro. If blank or not supplied, the current date is used.

3.Date Part - The portion of the date to add or subtract {Second, Minute, Hour, Day, Week, Month, Quarter, Year}.

4.Date Increment - An integer value of the date part unit to add or subtract.

5.Output Format String - A string used to format the date. If not supplied yyyy-MM-ddTHH:mm:ss.fffffffK is used.

6.Input Format String - A string that represents the format of the source date time string - only necessary when the date provided is not in a standard format.

 

Examples

[DateMath||Month|1]

Returns a value one month ahead of the current date time in the macro's default format.

 

[DateMath|12-Jan-2000|Day|1]

Returns the value 2000-01-13 in the macro's default format.

 

[DateTime||Year|1|yyyyMMdd]

Returns a value one year ahead of the current date time with the four-digit year, two-digit month, and two-digit day.

 

Notes

For a complete list of formatting options see the Date and Time Format Strings topic elsewhere in help.

 


Copyright © 2024 pasUNITY, Inc.

 

Send comments on this topic.