The value of DateDiff(DateInterval.Day, #1/1/2014#, #2/1/2014#) is 31.

Name: The value of DateDiff(DateInterval.Day, #1/1/2014#, #2/1/2014#) is 31.
Brand: Quizplus
Rating: 4.9 (34 reviews)

Question

Quizplus · Accepted Answer

The DateDiff function calculates the difference between two dates in a specified interval. In this case, the interval is Day and the two dates are January 1, 2014 (#1/1/2014#) and February 1, 2014 (#2/1/2014#). There are 31 days between these two dates, so the value of DateDiff(DateInterval.Day, #1/1/2014#, #2/1/2014#) is 31.

The Value of DateDiff(DateInterval.Day, #1/1/2014#, #2/1/2014#) Is 31