Calendar |
Sets the type of calendar. vbCalGreg or vbCalHijri. |
Date |
Returns the current system date as a Variant/Date. |
Date$ |
Returns the current system date as a String. |
Now |
Returns the current system date and time as a Variant/Date. |
Time |
Returns the current system time as a Variant/Date. |
Time$ |
Returns the current system time as a String. |
Timer |
Returns the number of elapsed seconds since midnight as a Single. |
DateAdd |
Returns a date with a given time interval added as a Variant/Date. |
DateDiff |
Returns the quantity of a given time interval between two given dates as a Variant/Long. |
DatePart |
Returns part of a given date as a Variant/Integer. *There is a bug in this function. The last Monday in some years can be returned as week 53 when it should be week 1. See here. |
DateSerial |
Returns a Variant/Date for a given year, month, and day. |
DateValue |
Returns a Variant/Date for a given string representing a date from 1/1/100 through 12/31/9999. |
Day |
Returns the day of the month as a Variant/Integer. |
Hour |
Returns the hour of the day as a Variant/Integer. |
Minute |
Returns the minute of the hour as a Variant/Integer. |
Month |
Returns the month of the year as a Variant/Integer. |
Second |
Returns the second of the minute as a Variant/Integer. |
TimeSerial |
Returns the time for a specific hour, minute, and second as a Variant/Date. |
TimeValue |
Returns the time given a string representing a time from 0:00:00 through 23:59:59 as a Variant/Date. |
Weekday |
Returns a whole number representing the day of the week as a Variant/Integer. |
Year |
Returns a whole number representing the year as a Variant/Integer. |