Author Topic: Microsoft Access Function Library: DateDiff()  (Read 2203 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1827
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Access Function Library: DateDiff()
« on: August 15, 2012, 05:26:47 PM »
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
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection