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