15. VIFRED Field Specifications : Derived Fields : Guidelines for Specifying Derivation Formulas : Constants in Derivation Formulas
Share this page                  
Constants in Derivation Formulas
You can use constants in derivation formulas for simple fields and for table field columns. For example, you can specify the derivation formula for Field_A as:
2 * field_b
Supported data types for constants in derivation formulas are char, varchar, c, text, integer, floating point, date, and money. Specify dates, money, and non‑numeric strings in single quotation marks, as:
'3‑6‑90' + field_b