Scheduled reports displaying dates in GMT rather than local timezone
I have created scheduled reports in a business admin portal. These reports use a Report Definition rule and the OOTB report scheduler to automatically email an Excel file to certain recipients about things such as number of cases created yesterday.
The issue I am facing is that in the reports run this way, DateTime properties such as .pxCreateDateTime are displayed in the Excel file in GMT, and I would like to display them in a different timezone. I am aware of the FormatDateTime function, however because the reports are run from a Report Definition rather than a Data Page I do not have the ability to apply a data transform. Is there a way to change the way that DateTimes are shown to the report recipients without changing the server timezone?
Also, I am attempting to use the generic "today" and "yesterday" date controls as a filter condition, it would be great if there was a way to stipulate a timezone context on these (e.g. 0100 AEST and 1500 AEST are different dates when translated into GMT, I would like "yesterday" and "today" to be in the context of AEST rather than GMT when the report is run). I could use a "difference in hours" comparison to manually adjust the time period captured, however this is awkward due to daylight savings time.
Any advice would be greatly appreciated.
Bits in Glass
IN
@IlanE953 Schedule reports gets the time zone from server's locale.
What you can do is you can create a job scheduler which runs in GMT format and based on operator's Locale you can delay the export report and sending email to the users using queue processor. So combination of job scheduler and queue processor can be used to achieve this.