Date and Time Functions
Function | Description |
---|---|
Cdate | Converts a valid date and time expression to the variant of subtype Date |
Date | Returns the current system date |
DateDiff | Returns the number of intervals between two dates |
DatePart | DatePart(inverval,date[,firstdayofweek[,firstweekofyear]]) |
DateSerial | DateSerial(year,month,day) |
Day | Returns a number that represents the day of the month (between 1 and 31, inclusive) |
Hour | Returns a number that represents the hour of the day (between 0 and 23, inclusive) |
IsDate | Returns a Boolean value that indicates if the evaluated expression can be converted to a date |
Minute | Returns a number that represents the minute of the hour (between 0 and 59, inclusive) |
Month | Returns a number that represents the month of the year (between 1 and 12, inclusive) |
Month/Name | Returns the name of a specified month |
Now | Returns the current system date and time |
Second | Returns a number that represents the second of the minute (between 0 and 59, inclusive) |
Time | Returns the current system time |
Timer | Returns the number of seconds since 12:00 AM |
Year | Returns a number that represents the year |