Data formatting

Try Pentaho Data Integration and Analytics

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11

Report Designer uses default formats for dates and numbers. You can change how dates and numbers display by selecting the object (field) and selecting the appropriate value for the format from the drop-down list next to format (under Attributes). In the example below, the dates associated with the Order Date field will display as MM-dd-yy.
Format field, Attributes

When you preview the report, notice that it displays in a cleaner format:
Order Date formatting applied

Note: You can type a value for your own format if you know the correct JavaScript string nomenclature.