April 2017
Intermediate to advanced
706 pages
17h 8m
English
The FORMAT function provides for the conversion of an expression of any data type (for example, integer, decimal, date, option, time, Boolean) into a formatted string. The syntax is as follows:
StringField := FORMAT( ExpressionToFormat [, OutputLength] [, FormatString or FormatNumber])
The formatted output of the ExpressionToFormat will be assigned to the output StringField. The optional parameters control the conversion according to a complex set of rules. These rules can be found in the Developer and IT Pro Help file for the FORMAT function and FORMAT property. Whenever possible, we should always apply FORMAT in its simplest form. The best way to determine the likely results of a FORMAT expression is to test it through ...
Read now
Unlock full access