Which of the following Access date functions determines a specific piece,or interval,of a date?
A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()

Question

Quizplus · Accepted Answer

The DatePart() function determines a specific piece or interval of a date such as the day, month, year, hour, minute, or second. This function can be used to extract specific information from a date/time field in Access. The other functions listed, DateSerial(), DateAdd(), and DateDiff() are also date functions in Access, but they are used for creating or manipulating dates, rather than determining a specific piece of a date.

Which of the Following Access Date Functions Determines a Specific