Convert eastern time stamp to pacific time at report level in web intelligence rich client

Hello,

I'm new to webi and having issues with a date field. I'm pulling in a date field that is eastern time zone and I'm trying to display in pacific. I cant find a function or any other way to convert. I know this has to be possible and is probably fairly easy, but I'm just not seeing how. Basically, I just need to subtract 3 hour from date/time field, but nothing I have tried is working. The version of webi is BO XI 3.1 and an oracle database. I need to do this at the report level, though. Cant make universe updates at this time, but seems it has to be possible as does not seem it is an uncommon need. Any insight would be greatly appreciated.
Thanks-
van-cougAsked:
Who is Participating?
 
van-cougConnect With a Mentor Author Commented:
Closing question; this worked: =RelativeDate([DATEFIELD];-3/24)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.