Excel export of Report showing "tt" in place of AM/PM

markjobsz

I have a report with date columns and we have formatted this date with this format "dd-MMM-yyyy hh:mm:ss tt". In the portal view, the report is showing the correct date format. But when I download the report, it is showing the date field with "tt" at last of it. Reports with date columns formatted with format "dd-MMM-yyyy hh:mm:ss tt" are showing "tt" in place of AM/PM in Excel on exporting.

surath_Decisions

It is an expected behavior. You need to do formatting on your excel to display the required date format.