cancel
Showing results for 
Search instead for 
Did you mean: 

How to change the data format in the FSM HTML report?

DAcker
Contributor
0 Kudos
417

Hello all,

I want to change the data format in the FSM HTML service checkout report.
I used the sample report from SAP documentation (https://help.sap.com/docs/SAP_FIELD_SERVICE_MANAGEMENT/fsm_html_reports/technical-details.html?locale=en-US&q=date), but the dates are shown as MM/DD/YYYY (see screenshot). In German I would like to change it to DD.MM.YYYY, but I couldnt find the right place in the files.

Similiar point for the formatting of the date time. I could like to display 07:30 - 08:30 (start - end date time) for German language). However, the current version displays the AM...
How can I delete this?

Thanks!
BR, Deborah

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello. Our HTML reports are using handlebars.js script for formatting things. when it comes to dates and time, you might want to check this brief explanation of possible formats https://docs.celigo.com/hc/en-us/articles/360045564992-Handlebar-expressions-for-date-and-time-forma.... Please search for format options in the places you want to modify. As an example from the example report:

headerKey: 'TimeRec_Day_L', propertyName: 'startDateTime', templateId: 'dateTimeTemplate', templateOptions: {formatString: 'L'},

You a see that it uses localized format "L". You can play around and modify this format string to fit your needs.

DAcker
Contributor
0 Kudos

Thank you, very helpful. I changed it and it did work! 🙂

Answers (0)