Input translation formulas
An input translation formula converts the data entered in the field to adjust the field value or make the field conform to a format. This formula executes when the document containing the field is saved.
An input translation formula should return a value of the same data type as the current field. For example, if the field is a Text field, the input translation formula should return a text string value. If the field is a Date/Time field, the input translation formula should return a date/time value.