DateDiff Function Parameters Return value DateDiff DateTime date1,``DateTime date2 TimeSpan Returns the interval (number of days, hours, minutes, seconds) between two dates. Example: DateDiff(#1/2/2009#, #1/1/2009#) = 1.00:00:00