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



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.




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



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



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



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.