15. VIFRED Field Specifications : Specify a Validation Check : Comparison Operator Validation Checks : Date and Money Comparisons
 
Share this page                  
Date and Money Comparisons
Enter comparison constants for abstract data types such as date and money in double quotation marks, as if they were character strings. For example:
date = "1‑Jan‑1988"
projecttable.budget > "$1000000"
The money data type is not supported by OpenSQL. For SQL, OpenSQL and QUEL equivalents, see the appendix "Data Types."