We have a query that has been successfully embedded into the Report Designer (Enterprise Report).
We want to display the "Last refresh" text element on the face of the report, so that users know when BW data was last updated.
However, the time returned is GMT, without adjustment for local time (ie, it should add ten hours).
The query itself returns the correct time when executed via the Query Designer, although in the query designer it's called "Status of Data", which displays GMT plus ten hours (for Australia).
How do we get Report Designer to show the correct LOCAL date and time?