Local Time to UTC Conversion

[Former Member]

Hi

Can anyone please tell me, is there any function in Business objects to convert the Local Time to UTC.

Scenario:

When user enter the Local Time in the report prompt, before sending it to the DB the business objects has to convert local time to UTC.

Please advise.

Thanks,

Lavanyaa TP

[Former Member]

if your universe is on SQL server this formula can work for you. For example for activity universe:

dateadd(hour,-datediff(hour,getdate(),getutcdate()),AUDIT_EVENT.Start_Timestamp)

or if you are using oracle this other link may help you:

[Former Member]

Hi

Could anyone please reply back on the above query?

Thanks,

Lavanyaa TP