Date and Time Functions

Use the statements and functions described here to perform date and time calculations.

Office Basic lets you calculate time or date differences by converting the time and date values to continuous numeric values. After the difference is calculated, special functions are used to reconvert the values to the standard time or date formats.

You can combine date and time values into a single floating-decimal number. Dates are converted to integers, and times to decimal values. Office Basic also supports the variable type Date, which can contain a time specification consisting of both a date and time.

Converting Date Values

The following functions convert date values to calculable numbers and back.

Converting Time Values

The following functions convert time values to calculable numbers.

System Date and Time

The following functions and statements set or return the system date and time.