Date Offset

Add or subtract day, month, year, hour, or minutes from all dates in a date column

Function:

DateOffset(table = string, date_col = string, offset = string, new_col = string)

Parameters:

Table: Table name on which to perform function

Date Column: Column to perform the offsets on

Date Offset Type: Offset type (Business End of Month, -1 year, -1 day....)

New Table Name: Name of the new table that will be created

Examples:

DateOffset(table = Budget, date_col = "Date", offset = "Business Month End", new_col = "Budget_2")