Skip to content

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

Date Formatting

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.

Custom Date Formatting

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.

Number Formatting

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.

Currency Formatting