XpressDox Help Center

Use Google To Find Help Fast, e.g. xpressdox choosefromlist


Press Getting Started in the XpressDox toolbar for basic template development
Watch the tutorial videos
View command help from list of commands
Press F1 for help on a command in the Command Editor
Email support@xpressdox.com for assistance

The LastDayInMonth Function


The LastDayInMonth Function

February is always a problem in that its last day depends on whether the year is leap or not.  XpressDox has the LastDayInMonth function to assist with this.

All that is required is to provide the function with a date and it will return the last day of the month in which that date occurs.

Some examples:

«LastDayInMonth(Today())»

On 12 August 2017, or any day in August 2017, this would return “2017-08-31”.

«FormatDate(LastDayInMonth(PeriodEndDate),'MMMM dd, yyyy')»

If PeriodEndDate was a date in February 2016, then the result would be “February  29, 2016”.

If PeriodEndDate was a date in February 2017, then the result would be “February 28, 2017”.