The FORMAT function allows you to convert 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 of StringField. The optional parameters control the conversion according to a complex set of rules. These rules can be found in Microsoft Docs 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 a range of the values to be formatted. We should make sure that we include the extremes of the range of possible values in our testing.
The optional OutputLength parameter can be zero (the default), a positive integer, or a negative integer. The typical OutputLength value...