_last_of_month
Returns a date or datetime, depending on the argument, that is the last day of the month represented by "date_expression".
Syntax
_last_of_month ( date_expression )Example 1
_last_of_month ( 2002-01-14 )Result
2002-01-31
Example 2
_last_of_month ( 2002-01-14 12:10:10.000 )Result
2002-01-31 12:10:10.000