Skip to Content
Former Member
May 06, 2010 at 01:29 PM

Display Local Time in Reports


Hello All,

We have implemented reports in which we are displaying the Name of person who executed the report, Last Execution time and Last Execution date.

H/w Detaails: Solaris OS, BOXIR3.1

Implementation Done:

="By " + DocumentAuthor() ", " LastExecutionDate() " at " LastExecutionTime()

Output: By Administrator, 5/6/10 at 2:10:11 PM GMT+00:00

Problem: Report run at 4:42PM IST shows timing as -

By Administrator, 5/6/10 at 2:10:11 PM GMT+00:00

IST = GMT+5:30

therefor the report time should have been: 11:12 AM

OR the local time of the user that is 4:42 PM.

Ideally the report time should be as per the user's time-zone.

Questions: Can we display user's local time zone in report.

Thanks & Regards

Sandeep Manocha