End of month

Returns the last day month from a date

Function:

EOMonth(table = string, col = string, new_col = string)

 

Parameters:

Table: Table name on which to perform function

Date Column: Column to return the last day of the month

New Column Name: Name of the column

 

Examples:

EOMonth(table = Budget, col = "Date", new_col = "End of Month")