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