Wrong date format in WeBi prompt refresh list

[Lee73]

Hi,
I have some problems with reports and WEBI:

in our Company, we have around 60 reports with date prompts,
they work perfectly on the BO full clients, when I put them on the Infoview they have problem in showing the
date prompts refresh lists: I have the Webi server regional setting set on Italian format dd/mm/yyyy, in the Infoview
refresh lists they are shown as mm/dd/yyyy..!?!?! :-(

I don't know how to solve this problem..
Could anyone help me?
Thanks in advance.

Ciao
Sabrina

 

[nimmy99]

What's your database?
SQL server, access ?

 

[Lee73]

hi Nimmy,

my db is an Oracle8.1
I try to check some date fields in the db and it seems
correct dd/mm/yyyy
hope this can help you..

Sabry

 

[nimmy99]

We had the same issue, found that it's because of the ODBC driver.

Just try to use both
Oracle client (native driver)
ODBC driver

and test your results.