LastOfTheMonth

 

 

 

LastOfTheMonth

 

Description

Returns the last of the month for the supplied date.

 

Arguments

1.LastOfTheMonth - Name of the Macro.

2.Date Time String - A string representing the date time to use for the macro.

3.Input Format String - A string that represents the format of the source date time string.

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

 

Examples

[LastOfTheMonth|[DateTime]]

Returns the last of the current month in yyyy-MM-ddTHH:mm:ss.fffffffK format.

 

[LastOfTheMonth|3/8/11|M/d/yy|yyyy-MM-dd]

Returns 2011-03-31. Note that this date will not parse without supplying an input format.

 

[LastOfTheMonth|8-January-2010||yyyyMMdd]

Returns 20100131.

 

[LastOfTheMonth|[Copy|TransactionDate]||yyyyMMdd]

Returns the last of the month for the transaction date in the supplied format.

 

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.