Open topic with navigation

Date/time statements

Date/time statements convert, query, and return date/time values.

Statement Description
Date Returns the date in MM/DD/YYYY format based on integers that represent the year, month, and day.
DateAdd Adds a time to a date/time value and returns the resulting value in the short date and time format used on the test computer.
DateDiff Returns the difference between two date/time values based on an interval type.
DatePart Returns a part from a date/time value as an integer.
DateTime Returns the date and time in MM/DD/YYYY format based on integers that represent the year, month, day, hour, minute, and second.
DateTimeFormat Returns the date or time in a specified format.
Day Returns the day from a date/time value.
Hour Returns the hour from a date/time value.
IsDate Returns True or False to indicate if a date/time string is valid.
Minute Returns the minute from a date/time value.
Month Returns the month from a date/time value as an integer.
MonthName Returns a month name based on a month integer.
MonthNum
Returns a month integer based on a month name.
Now Returns the current date and time in the format used on the test computer.
Second Returns the seconds from a date/time value.
Time Returns the time in seconds since epoch (January 1, 1970 12:00 AM).
Today Returns the current date in MM/DD/YYYY format.
Weekday Returns a weekday integer that represents the day of the week for a date.
WeekdayName Returns a weekday name based on a weekday integer.
WeekdayNum
Returns a weekday integer based on a weekday name.
Year Returns the year from a date/time value.