MySafeInfo

MS Access Date Functions

Technology 20 records updated 2026-07-17

MS Access Date Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/msaccessdatefunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against msaccessdatefunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 20 of 20 records. Click a column to sort these rows.

ID Function Description
1 Date Returns the current system date
2 DateAdd Adds a time/date interval to a date and then returns the date
3 DateDiff Returns the difference between two dates
4 DatePart Returns a specified part of a date (as an integer)
5 DateSerial Returns a date from the specified parts (year, month, and day values)
6 DateValue Returns a date based on a string
7 Day Returns the day of the month for a given date
8 Format Formats a date value with the specified format
9 Hour Returns the hour part of a time/datetime
10 Minute Returns the minute part of a time/datetime
11 Month Returns the month part of a given date
12 MonthName Returns the name of the month based on a number
13 Now Returns the current date and time based on the computer's system date and time
14 Second Returns the seconds part of a time/datetime
15 Time Returns the current system time
16 TimeSerial Returns a time from the specified parts (hour, minute, and second value)
17 TimeValue Returns a time based on a string
18 Weekday Returns the weekday number for a given date
19 WeekdayName Returns the weekday name based on a number
20 Year Returns the year part of a given date

Notes