Skip to main content
July 12, 2023
Question

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

  • July 12, 2023
  • 1 reply
  • 0 views

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:

1 reply

mathieud0001
July 12, 2023

Simply use the customCellPositions and customCellValues to add an extra column with the formatted date in text format.