Currency and Phone Field Format Strings

The table below lists the format string options for currency and phone number fields.

Field Type Option Description
Currency m Money. The format of the field must be a floating-point value. The value is converted to a string that represents a currency amount.
Phone Number # Use the # sign to indicate how you want a number to display. You can use any character as a separator except letters and numbers. The default phone number format is (###) ###-####.

A format string must begin with a % sign and end with a format type character:

[%] [type]

Related Topics

Assigning a Query Layout

 

 

 

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.