---
title: Date Difference
description: Return the value of the difference of two dates
---

[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 Difference

## Return the value of the difference of two dates

***Function:***

DateDiff(table = *string*, start_col = *string*, compare_col = *string*, new_col = *string*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Start Column*: Column to derive the date difference

*Column to Compare*: Column to compare to the start column for the date difference

*New Column Name:* Name for the new column

 

***Examples:***

DateDiff(table = Sales_Commish_Detail, start_col = "Begin Month", compare_col = "Test Date", new_col = "Date Diff")