Working on the 6.5 BO Report on Deski.
This about Date.
I am useing INLIST option for DATE in Report Query panel. And running the report based on that selecion.
The problem is When I Select values from LOVs for DATE in condition.I am getting Diffrent formate(DD/MM/YYYY) for 1st to 12 days and From 13th formate is (MM/DD/YYYY),
When I run the query with that values.I am getting wrong information.
My Update:
1.In database all the dates are in one Formate MM/DD/YYYY.
2.Its getting changed only when I select in codition.
3.Changed the Common formate in Universe, Didnt Worked.
4.Created Variable,Didnt Worked.
BO is trying to match the front end date format (local setting on your computer AND locale of the full client itself.
Probably one of those is on the format dd/mm/yyyy.
It switches to a different format when the typed date is obviously a different date format then expected.
(so if you type 03/31/2009, it knows the second part cant be a month, so it assumes the format to be mm/dd/yyyy)
So first thing would be to check and set those locales consistent with your database locale.
Now because this is sure to happen again to other users,
as a best practice, fix the date format by presenting it to the users in a ‘string’ format.
Also ask them to type it in in a certain format.
So a prompt message like ‘Give order date (yyyymmdd)’
In your universe convert the prompt answer string(s) to date,
and convert the date LOV(s) to string versions.
Notice that using yyyymmdd (or yyyy-mm-dd) will sort better than ‘dd-mm-yyyy’
(BOB member since 2004-05-03)
(BOB member since 2002-08-20)