Microsoft Access Function Library: DateDiff()

[bbasujon]

Function: DateDiff()

Purpose: The DateDiff() function returns the difference between two dates.

Usage: DateDiff(interval, date1, date2)

Interval may be set to:

    yyyy for year
    q for quarter
    m for month
    y for day of year
    d for day
    w for weekday
    ww for week
    h for hour
    n for minute
    s for second



Returns: Number of intervals between date1 and date2.

Examples and Special Cases

DateDiff("yyyy", "6-Nov-2006", "7-Nov-2006") returns 0
DateDiff("yyyy", "31-Dec-2006", "1-Jan-2007") returns 1
DateDiff("d", "6-Nov-2006", "8-Nov-2006") returns 2