Applies to Infiniti v8.1 or later
 
Returns a string created by formatting a value in the specified style.

Usage

 
Format( e, f )

Parameters:

e An expression or value to be formatted, which may include equations, question references and function calls.
 
f The format string to apply to the expression.

Examples

Format the current date:
 
- Format(today(),”long date”) -> “Friday, 1 January 2000”
- Format(today(),”dd MMM yyyy”) -> 01 Jan 2000
- For further details of date formatting, see http://ixsupport.intelledox.com/kb/a357/custom-date-time-format-strings.aspx
 
Format a number to always show digits/decimal places:
 
- Format([q1],”{0:#.0}”) -> will always show one decimal place (e.g. 5.0 for the value 5) and and only show units if they exist (e.g. “.1” for the value 0.1)
- For further details of number formatting, see http://ixsupport.intelledox.com/kb/a359/custom-numeric-format-strings.aspx
 
Format a string to “title case” (first letter of each word capitalized):
 
- Format([q1],”+-+-“)
 
Note: Infiniti 8.5 introduces support for Special Formats: +, -, +- and +-+- , all other Special Formats are not supported in this function. For more details see Special format strings.

Related Articles

Keywords

customise dateformat