Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind MS Access Format() 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.
___ Format(BirthDate, "Long Date") AS FormattedBirthDate3Order
Put the learning moves in the order that makes the concept easiest to apply.
The Format() function formats a date value with the specified format.
Definition and Usage
MS Access Format() Function
Example
SELECT Format(BirthDate, "Long Date") AS FormattedBirthDate
FROM Employees;Definition and Usage
The Format() function formats a date value with the specified format.
Syntax
Format(
value
,
format
,
firstdayofweek
,
firstweekofyear
)Parameter Values
| Parameter | Description |
|---|---|
| value | Required. The date value to format |
| format | Optional. The format to use. Format Description General Date Shows value as a date based on the system settings Long Date Shows value as a date based on the system's long date settings Medium Date Shows value as a date based on the system's medium date settings Short Date Shows value as a date based on the system's short date settings Long Time Shows value as a date based on the system's long time settings Medium Time Shows value as a date based on the system's medium time settings Short Time Shows value as a date based on the system's short time settings |
| Format | Description |
| General Date | Shows value as a date based on the system settings |
| Long Date | Shows value as a date based on the system's long date settings |
| Medium Date | Shows value as a date based on the system's medium date settings |
| Short Date | Shows value as a date based on the system's short date settings |
| Long Time | Shows value as a date based on the system's long time settings |
| Medium Time | Shows value as a date based on the system's medium time settings |
| Short Time | Shows value as a date based on the system's short time settings |
| 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 |
| Format | Description |
|---|---|
| General Date | Shows value as a date based on the system settings |
| Long Date | Shows value as a date based on the system's long date settings |
| Medium Date | Shows value as a date based on the system's medium date settings |
| Short Date | Shows value as a date based on the system's short date settings |
| Long Time | Shows value as a date based on the system's long time settings |
| Medium Time | Shows value as a date based on the system's medium time settings |
| Short Time | Shows value as a date based on the system's short time settings |
- 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 |
|---|