BusinessObjects Board

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


sandeep.manocha :us: (BOB member since 2009-06-17)