In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?
A)Date - DueDate
B)Today - [DueDate]
C)Day() - [DueDate]
D)Date() - [DueDate]

Question

Quizplus · Accepted Answer

The correct expression is D) Date() - [DueDate]. This uses the Date() function to get the current date and subtracts the value in the DueDate field to calculate the number of days between them. The Date() function is used in Access to return the current date.

In Access Query Design View, Which of the Following Expressions