Determines the integer number of datepart units by which date1 is less than date2.
dateDiff(datepart, date1, date2)
→ returns numeric
Find the difference between two dates.
dateDiff("d", "2013-01-15", "2013-01-25")
Expected Result: 10
Calculates a persons age based on a variable birthDate which contains a date. Uses the now function to get current date.
dateDiff("yyyy", birthDate, now())
Note the different behavior between ColdFusion and Lucee.
testDate = now(); diffDate = dateAdd('d', 1, testDate); writeOutput(testDate.diff('d', diffDate)); // this returns 1 on Lucee, and -1 on ColdFusion