How do I adjust time zone ins rtf date field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I adjust time zone ins rtf date field

I'm configuring a RTF template to a term document, but here's my problem, in that document it must contain the from date of a compensation plan, but when I put the field and set to return with the date format dd/MM/yyyy, the OTBI return the day before, doing a research I reach this code <?xdofx:to_char(xdoxslt:adjust_datetime(FROM_DATE, 'PT-3H'), 'dd/MM/yyyy')?> that promise that will adjust the date to the correct time zone wich is GMT -3 (I'm from Brazil), but when I put this code on the RTF nothing returns on OTBI, I even try to pu this inside a for-each structure to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!