Calculates the difference between two dates, returns the amount of time in the specified units (day, year, month etc.) between a start and end date.
int? DATEDIFF(string part, DateTime? startdate, DateTime? enddate)
|part||String||A string to represent the time unit (year,month,day,hour,minute,second).|
|startdate||DateTime||A start DateTime.|
|enddate||DateTime||An end DateTime value.|
DATEDIFF("month", DATEVALUE("2016-05-02"), DATEVALUE("2017-02-25"))
Will return '9' as there are nine months between the two dates.
DATEDIFF("day", TODAY(), CreatedDate)
Will return the difference in days between Today's date and the date stored in the CreatedDate field for each record.