Date Operators

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

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:

OperationSyntaxReturnsExpressionValue
Date differenceDate – DateNumber!1/20/97! – !1/1/97!19
Day additionDate + NumberDate!1/20/97! + 9!1/29/97!
Day subtractionDate – NumberDate!1/20/97! – 9!1/11/97!

See Also

Bitwise Operators, Comparison Operators, Logical Operators, Numeric Operators, Operators, Picture Operators, String Operators, Time Operators.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next