Format String

Use a format string to format the data displayed in the query. First, select the format type. Then, type a format string to modify the format type you selected. The valid options depend on the format type you select. A format string must begin with a % sign and end with a format type character:

[%] [type]

If necessary, you can also include:

[%] [index:] [-] [width] [.precision] [type]

To specify how many decimals to use in a format string, set the format string to the normal format you would use. Then, add the precision specifier - a decimal point and the number of digits to follow it - before the format string character but after the initial %. For example:

  • Field Type: Float
  • Format Type: ftCurrency.
  • Format String: %.4f
  • Data (Unformatted): 3.1415926&ldots;
  • Result: 3.1416

You can use any of the following types of format strings:

Related Topics

Query Builder Overview

 

 

 

What's New in this Release

 

For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at documentation@infor.com.