This content has been marked as final. Show 4 replies
You will need to use the appropriate locale. In our case, we are in Qatar, hence we will use the following date format:
Have a look at this document:
In the RTF template, do not use the Microsoft formatting mask for any of your "Date" fields.
Please follow the steps below :
1) In the RTF template, do not use the Microsoft format mask for the field,
but use the Oracle abstract formatting mask instead.
That is, under the Properties tab for that field, make sure the type
is "Regular Text" and not "Date".
2) In the Advanced tab, change the following (do this for each of the date
fields) to use the Oracle formatting mask:
3) Don't forget to include 'UTC', this is the main part of the workaround.
The issue is that when XDO engine does not see a UTC offset in the date field
in the XML data, it assumes the Date is in UTC/GMT timezone and so attempts to
convert it to your timezone as specified under your personalization settings.
This conversion can obviously affect the day. If you specify a UTC timezone in
the format-date function, then it won't attempt a conversion.
I am also facing same issue. If i am runing report directly through publisher output is coming correct.
But if I am runing through WSDL report out put is showing one day prior date(e.g. dob is 05-Jun-1970 in database, Same coming in xml but out put is showing 04-jun-1970)
If any body is having any idea for this issue pls help me.