Hi,
I am facing the date display problem in DesktopIntelligence reports.
Problem Description:All the reports are showing the date format as required(DD/MM/YYYY HH:MM:SS AM/PM) but when i access the same set of reports from Infoview the Date format is displaying in Arabic(AM/PM displaying in Arabic).
The BO and Oracle versions which are currently installed in my Environment:BOXIR2(SP1),Oracle10g Tomcat Webserver
Any inputs/Suggessions on this problem is highly appreciated.
How the Reports Date are displaying in Desk I? I hope your Database storing the Date in Arabic, the same is displaying in the report also.
Check whethe the report is showing the same Date format in Desk I and Infoview.
Hi Siva,
Dates are storing in the data base in english format only.here i used the Currentdate() function in Report Header for displaying Report refreshed date it is displaying in English format as we required.
Issue is when i refresh the report in Infoview its displaying in Arabic.
I feel its should be some infoview setting problem.
i checked the settings also as follows
Preferences–>General->My Interface Locale is “English United States”
My Current Time zone is–>“Local to Web server”
Strange thing is its happening only for few reports remaining reports are showing correctly.
The Current Date is Different from the Date from the Database… Please check the System date of Your Database if your in oracle, select sysdate from dual or Select *from nls_database_parameters
Hi Siva,
the date format in the database as follows
Nls_date_Language=‘AMERICAN’
Nls_date_format=‘DD-MON-RR’
NLS_TIMESTAMP_FORMAT=DD-MON-RR HH.MI.SSXFF AM
when i try to display any date as a column in the report body it will show as like as database format.so I don’t think its a database related problem if i am not wrong.
(BOB member since 2008-01-10)
(BOB member since 2006-02-08)
(BOB member since 2006-02-08)