Which of the following Access date functions determines the difference between two dates?
A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()

Question

Quizplus · Accepted Answer

The DateDiff() function is used to determine the difference between two dates in Access. It takes three arguments: the interval to measure the difference (e.g. days, months, years), the starting date, and the ending date. DateSerial() is used to create a date value from separate day, month, and year values. DateAdd() is used to add a specified time interval to a date, and DatePart() is used to extract a specific portion of a date (e.g. the day, month, or year).

Which of the Following Access Date Functions Determines the Difference