Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind MS Access DateDiff() Function?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ DateDiff("yyyy", #13/01/1998#, #09/05/2017#);3Order
Put the learning moves in the order that makes the concept easiest to apply.
The DateDiff() function returns the difference between two dates.
Definition and Usage
MS Access DateDiff() Function
Example
SELECT DateDiff("yyyy", #13/01/1998#, #09/05/2017#);Definition and Usage
The DateDiff() function returns the difference between two dates.
Syntax
DateDiff(
datepart
,
date1
,
date2
,
firstdayofweek
,
firstweekofyear
)Parameter Values
| Parameter | Description |
|---|---|
| datepart | Required. The part to return. Can be one of the following values: yyyy = Year q = Quarter m = month y = Day of the year d = Day w = Weekday ww = Week h = hour n = Minute s = Second |
| date1 and date2 | Required. The two dates to calculate the difference between |
| firstdayofweek | Optional. Specifies the first day of the week. Can be one of the following values: 0 = Use the NLS API setting 1 = Sunday (this is default) 2 = Monday 3 = Tuesday 4 = Wednesday 5 = Thursday 6 = Friday 7 = Saturday |
| firstdayofyear | Optional. Specifies the first week of the year. Can be one of the following values: 0 = Use the NLS API setting 1 = Use the first week that includes Jan 1st (default) 2 = Use the first week in the year that has at least 4 days 3 = Use the first full week of the year |
- yyyy = Year
- q = Quarter
- m = month
- y = Day of the year
- d = Day
- w = Weekday
- ww = Week
- h = hour
- n = Minute
- s = Second
- 0 = Use the NLS API setting
- 1 = Sunday (this is default)
- 2 = Monday
- 3 = Tuesday
- 4 = Wednesday
- 5 = Thursday
- 6 = Friday
- 7 = Saturday
- 0 = Use the NLS API setting
- 1 = Use the first week that includes Jan 1st (default)
- 2 = Use the first week in the year that has at least 4 days
- 3 = Use the first full week of the year
Technical Details
| Works in: | From Access 2000 |
|---|