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.

Function Today()

Special format strings

Infiniti functions - Overview

Keywords

customise dateformat

Article ID: 149, Created: July 31, 2012 at 3:09 PM, Modified: February 27, 2017 at 9:21 AM

Function Format()

Usage

Parameters:

Examples

Related Articles

Keywords

Was this article helpful?

Share this article