convert datetime row in a!exportDataStoreEntityToExcel() to display AM/PM format

Certified Senior Developer

Hi all,

I want to mimic my grid data in an excel report, the issue is that one of fields that I want to export is set to datetime in a DB and I want it to display AM/PM format in a report. Is there a way to convert datetime field for every cell in that column in a report?

DB:

Grid and conversion:

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data