powered by
Returns the last day of a month.
LastDayOfMonth(year, month, date = NULL)
Last day of the month in the current year.
Year as a number.
Month as a number.
If provided, uses year and month from this date. It could be date or a string format date YYYY-MM-DD.
Diego Jara
# Return last day of the month in year LastDayOfMonth(year = 2020, month = 2) # Return last day of the month for the date LastDayOfMonth(date = '2020-02-03')
Run the code above in your browser using DataLab