4D v14.3
Date Operators
Date Operators
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! |
Product: 4D
Theme: Operators
Bitwise Operators
Comparison Operators
Logical Operators
Numeric Operators
Operators
Picture Operators
String Operators
Time Operators
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
