I want to create a filter as "Invoice Date Between : < User Input1> and
for one of my reports.
But while creating the prompt, it accepts the date as dd/mm/yyyy and adds the time format automatically.
User wants to enter the Invoice Date in : mm/dd/yyyy format only
My InputDate Format in .sbo file is set to : mm/dd/yyyy (no time part)
In the Universe, the format of the object “Invoice Date” is also set to : mm/dd/yyyy
We are using Oracle 9i DB.
When i’m creating a report with a constant date value like : invoice date = ‘01/02/2004’
as soon as i complete entering the value, time part is getting added i.e.,
invoice date = ‘01/02/2004 12:30:00 PM’
i need to avoid this
This input format should be of ‘mm/dd/yyyy’
The above condision is fetching me the data for 01 FEB 2004
but my input is for 02 JAN 2004
How do i set this right?
As i mentioned earlier, i’ve changed the .sbo file,
also, invoice date object has the format set to ‘mm/dd/yyyy’