I am using Excel Exporter module to create a custom excel report. I have a scheduled event, that create a excel using the template created in application and send the created excel in Mail to the respective users. The issue is, the datetime in excel report, is in UTC(same in DB), In application, it shows in IST, which is correct, But I also want datetime in IST in excel. FYI, In application settings -> scheduled event time zone is in IST. Requesting suggestions on this regard.
asked
Sudarsanam Srinivasan
2 answers
0
Please change the date field as localised in the domain model
answered
Rachana BP
0
Hi Sudarsanam,
ideally it should show in IST as datetime is in localized , but if it is showing in UTC , workaround could be to then subtract the offset hours between UTC and IST for that attribute in Schedule event mf.