---
title: Date Offset
description: Add or subtract day, month, year, hour, or minutes from all dates in a date column
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# 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")