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.