version 6.0
An expression that uses a date operator returns a date or a number, depending on the operation. All date operations will result in an accurate date, taking into account the change between years and leap years. The following table shows the date operators:
Operation | Syntax | Returns | Expression | Value |
Date difference | Date Date | Number | !1/20/97! !1/1/97! | 19 |
Day addition | Date + Number | Date | !1/20/97! + 9 | !1/29/97! |
Day subtraction | Date Number | Date | !1/20/97! 9 | !1/11/97! |
See Also
Bitwise Operators, Comparison Operators, Logical Operators, Numeric Operators, Operators, Picture Operators, String Operators, Time Operators.