Date and Number Formatting¶
Date/Time Formatting¶
IFS Report Studio provides versatile date and time formatting options, enabling the presentation of date and time values in various formats. Users can leverage both standard and custom format strings to achieve their desired data display.
Standard Date Format Strings¶
Format String | Description | Example Usage | Example Output |
---|---|---|---|
d |
Short date pattern | {0:d} |
en-US: 2/7/2025, sv-SE: 2025-02-07 |
D |
Long date pattern | {0:D} |
en-US: Friday, February 7, 2025, sv-SE: fredag 7 februari 2025 |
f |
Full date/time (short time) | {0:f} |
en-US: Friday, February 7, 2025 1:45 PM sv-SE: fredag 7 februari 2025 13:45 |
F |
Full date/time (long time) | {0:F} |
en-US: February 7, 2025 1:45:30 PM sv-SE: fredag 7 februari 2025 13:45:30 |
g |
General date/time (short time) | {0:g} |
en-US: 2/7/2025 1:45 PM, sv-SE: 2025-02-07 13:45 |
G |
General date/time (long time) | {0:G} |
en-US: 2/7/2025 1:45:30 PM, sv-SE: 2025-02-07 13:45:30 |
M or m |
Month day pattern | {0:M} |
en-US: February 7, sv-SE: 7 februari |
Y or y |
Year month pattern | {0:Y} |
en-US: February 2025, sv-SE: februari 2025 |
Custom Date Format Strings¶
Format String | Description | Example Usage | Example Output |
---|---|---|---|
M/d/yy |
Custom short date | {0:M/d/yy} |
en-US: 2/7/25, sv-SE: 2-7-25 |
MM/dd/yyyy |
Custom long date | {0:MM/dd/yyyy} |
en-US: 02/07/2025, sv-SE: 02-07-2025 |
dddd, MMMM dd, yyyy |
Custom full date | {0:dddd, MMMM dd, yyyy} |
en-US: Friday, February 07, 2025, sv-SE: fredag, februari 07, 2025 |
Note
When custom date format strings are used, the specified date and time pattern remains consistent at runtime, regardless of the locale.
Number Formatting¶
IFS Report Studio offers flexible number formatting options, allowing numeric values to be displayed in various formats. Users can utilize standard format strings to present numbers in a manner that meets their reporting requirements
Format String Table¶
Format String | Description | Example Usage | Example Output |
---|---|---|---|
n or N |
Number with commas | {0:n} |
en-US: 1,234.56, sv-SE: 1 234,56 |
n1 |
Number with one decimal place | {0:n1} |
en-US: 1,234.6, sv-SE: 1 234,6 |
Note
The nX format in number formatting specifies the number of decimal places, where X can range from 0 to 9.
Currency Formatting¶
Currency formatting in IFS Report Studio allows numeric values to be displayed as currency. Users can use standard format strings to format numbers as currency, reflecting the appropriate locale settings.
Format String Table¶
Format String | Description | Example Usage | Example Output |
---|---|---|---|
c or C |
Currency | {0:c} |
1,234.56 |
c1 |
Currency with one decimal place | {0:c1} |
1,234.6 |
Note
The cX format in currency formatting specifies the number of decimal places, where X can range from 0 to 9.