Date and Time Functions

FunctionDescription
CdateConverts a valid date and time expression to the variant of subtype Date
DateReturns the current system date
DateDiffReturns the number of intervals between two dates
DatePartDatePart(inverval,date[,firstdayofweek[,firstweekofyear]])
DateSerialDateSerial(year,month,day)
DayReturns a number that represents the day of the month (between 1 and 31, inclusive)
HourReturns a number that represents the hour of the day (between 0 and 23, inclusive)
IsDateReturns a Boolean value that indicates if the evaluated expression can be converted to a date
MinuteReturns a number that represents the minute of the hour (between 0 and 59, inclusive)
MonthReturns a number that represents the month of the year (between 1 and 12, inclusive)
Month/NameReturns the name of a specified month
NowReturns the current system date and time
SecondReturns a number that represents the second of the minute (between 0 and 59, inclusive)
TimeReturns the current system time
TimerReturns the number of seconds since 12:00 AM
YearReturns a number that represents the year