Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Date.EndOfMonth(dateTime as any) as any
About
Returns the end of the month that contains dateTime.
dateTime: Adate,datetime, ordatetimezonevalue from which the end of the month is calculated.
Example 1
Get the end of the month for 5/14/2011.
Usage
Date.EndOfMonth(#date(2011, 5, 14))
Output
#date(2011, 5, 31)
Example 2
Get the end of the month for 5/17/2011 05:00:00 PM -7:00.
Usage
Date.EndOfMonth(#datetimezone(2011, 5, 17, 5, 0, 0, -7, 0))
Output
#datetimezone(2011, 5, 31, 23, 59, 59.9999999, -7, 0)