BusinessObjects Board

Input Date Format

building reports desktopintelligence
#1

Hello,

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.

Any suggestions to overcome this problem?

Thanx in advance

Sho (BOB member since 2004-04-27)

#2

Do you mean the LOV shows the Time Portion for the Dates??? If so check this link

Designer FAQ

Sridharan :india: (BOB member since 2002-11-08)

#3

No, Not LOV.
Its just a siple Date Imput Field

Sho (BOB member since 2004-04-27)

#4

So if the User enters jus the Date value where exactly are you getting the Time Portion…

Sridharan :india: (BOB member since 2002-11-08)

#5

These are the problems :

  1. 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

  1. 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’

rgds

Sho (BOB member since 2004-04-27)