Date and Time
|
Date Function |
Returns the current system date |
|
DateAdd Function |
Returns the result of a data/time addition or subtraction calculation |
|
DateDiff Function |
Returns the difference between two dates |
|
DatePart Function |
Returns the part of the date requested |
|
DateSerial Function |
Returns a date from an expression containing month, day and year |
|
DateValue Function |
Returns a date from a representation of a date |
|
Day Function |
Returns a number representing the day of the week |
|
Hour Function |
Returns a number representing the hour of the day |
|
Minute Function |
Returns a number representing the minute of the hour |
|
Month Function |
Returns a number representing the month of the year |
|
MonthName Function |
Returns the name of the month for a given date |
|
Now Function |
Returns the current system time |
|
Second Function |
Returns a number representing the second of the minute |
|
Time Property |
Returns or sets the current system time as a variant |
|
Timer Property |
Returns the number of seconds elapsed since midnight |
|
TimeSerial Function |
Returns a representation of a given hour, minute and second |
|
TimeValue Function |
Returns a time value from a string representation of a time |
|
Weekday Function |
Returns a number representing the day of the week |
|
WeekdayName Function |
Returns a string indicating the day of the week |
|
Year Function |
Returns a number representing the year in a date expression |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access