lov time and month year as date issues

[system]

Hi all,

I have converted month-year in the format 08/2008 to date
in the format mm/dd/yyyy in SQL server 2005 using the convert function.(101 format) so 08/2008 appears as 08/01/2008.

I had to do this so that it is recognized as a date and I can then use it in my report to do a ‘month-year’ between operation.

(1). Is it possible to do the between operation without converting month-year into date in the format mm/dd/yyyy?

(2). Also when I drag the converted object in the report - it shows up
correctly as 08/01/2008 but when I see the list of values in the prompt,

• the default time of 12:00:00 AM is automatically inserted

Why does this happen - is there a database or BO.prm setting I need to change? How do I get rid of this default time and show only the date in the format mm/dd/yyyy like 08/01/2008 in lov?

Answer to these questions would be very helpful!

thanks
ajq

---

anushajq (BOB member since 2005-02-22)

[system]

@anushajq

(2). Also when I drag the converted object in the report - it shows up
correctly as 08/01/2008 but when I see the list of values in the prompt,

• the default time of 12:00:00 AM is automatically inserted
  Why does this happen - is there a database or BO.prm setting I need to change? How do I get rid of this default time and show only the date in the format mm/dd/yyyy like 08/01/2008 in lov?

Hi,

This question is asked on BOB at least once a month. Last time it was this discussion:

LIST OF VALUES -Ricardo-

I have a list of values with a date format field -oracle data base- which is visualized in the format DD/MM/YYYY H:MM:SS I want it to be visualized in format DD/MM/YYYY but I do not Know how to do it. When using “TRUNC” I only get the hours, minutes and seconds to be 0, but I am not able to make them disappear of the list of values. How can I do then?. Thankyou for your time. Ricardo. PRGG1 (BOB member since 2008-09-05)

Please do a search before you post a question.

---

Marek Chladny (BOB member since 2003-11-27)