Date in prompt

building semantic layer
1

Hi,

I am using BO 6.5 with SQL Server 2000.

I have a date feild(02/01/2005) in my database. When I create a prompt at report level using this date feild,in the list of values for this date prompt i have the date as 02/01/2005 12:00:00 AM. I need to get rid of the 12:00:00 AM in my date list. I need only 02/01/2005 in my list.

Help me in acheiving this.

Thanks in advance.

ksmurthys (BOB member since 2004-12-22)

2

Murthy,

Check This Topic or This topic

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

3

Kashif,

Thanks for the help. Is there any way to create a prompt without List of values.

ksmurthys (BOB member since 2004-12-22)

4

When you create a prompt using the @PROMPT function you can:

A) Use a universe LOV
B) Hardcode the list of values into the @Prompt
C) Provide no LOV at all

Andreas :de: (BOB member since 2002-06-20)

5

Andreas,

Thanks. I got you.

ksmurthys (BOB member since 2004-12-22)

6

When prompting for dates (true dates, not character representations), most people find LOVs add little value. It’s faster just to type it in.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)