DateDiff()

Determines the integer number of units by which date1 is less than date2.

With Lucee 6, the order of the arguments for this .diff() member function was changed to match ACF

LDEV-2044

DateDiff( datePart=string, date1=datetime, date2=datetime );

Returns: Number

Argument Description
datePart
string, required

The specific units in which to count:

  • yyyy: Years
  • q: Quarters
  • m: Months
  • y: Day of Year (same as d)
  • d: Days (same as y)
  • w: Weeks (same as ww)
  • ww: Weeks (same as w)
  • wd: Weekdays
  • h: Hours
  • n: Minutes
  • s: Seconds
  • l: MilliSeconds
date1
datetime, required

date object; for example, now()
date2
datetime, required

date object; for example, now()

Examples

echo( DateDiff( "d", "2016-06-27", "2016-06-28" ) & "<br>" ); // 1
echo( DateDiff( "d", "2016-06-27", "2016-06-27" ) & "<br>" ); // 0
echo( DateDiff( "d", "2016-06-27", "2016-06-26" ) & "<br>" ); // -1

echo( DateDiff( "h", "2016-06-27 00:00:00", "2016-06-27 01:00:00" ) & "<br>" ); // 1
echo( DateDiff( "h", "2016-06-27 00:00:00", "2016-06-27 00:00:00" ) & "<br>" ); // 0
echo( DateDiff( "h", "2016-06-27 01:00:00", "2016-06-27 00:00:00" ) & "<br>" ); // -1
echo( DateDiff( "wd", "2016-06-27 00:00:00", "2016-07-27 01:00:00" ) & "<br>" ); // 22

See also