I have a scenario where I use exportEntityToExcel smart service to export a VIEW data (script below) in an excel file. There is one filed which has datatime (CREATED_ON) in it. I want to display/export to excel the timezone along with datetime in this field.
Existing Format: 11/27/23 02:43
Expected Format: 11/27/23 02:43 AM/PM PST/CST/MST/EST
.
CREATE VIEW `DUMMY_VW` AS SELECT `b`.`CITY` AS `CITY`, `i`.`CREATED_ON` AS `CREATED_ON`, `i`.`CREATED_MONTH` AS `CREATED_MONTH`, `i`.`CREATED_YEAR` AS `CREATED_YEAR`, FROM (`DUMMY_STATUS` `i` left join `DUMMY_PROFILE` `b` on(`i`.`ID` = `b`.`D_ID`)) ;
Discussion posts and replies are publicly visible
exportDataStoreEntityToExcel is limited in the formatting you can apply to the output data, but you could try converting your CREATED_ON field from an actual datetime to a formatted text string in your view and then exporting that