remoe the timestamp from the date

[system]

hi

i have a weekly report where the records are displayed within the date range entered by the user.

Below is the start_date object with the following definition.
next_day(@Prompt(‘Please Enter the Start Date’,‘D’,mono,free),‘Monday’)-7

here when the user selects the date from the calender i see the timestamp also gets appended to the date as shown below.

next_day(‘05-08-2008 00:00:00’,‘Monday’)-7

I want to remove this timestamp. Should i have to modify the object definition. I tried with to_date() also. But it is not working.

Can anyone suggest me how to implement this?

Thanks in advance

---

breeze_08 (BOB member since 2008-04-03)

[system]

That’s the way it works. There is a FAQ post with more detail, and if you search for “LOV TIME” you will probably find many more topics on the same subject.

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

If you going against SQL Server,

Try looking at this thread

Convert mm/dd/yyyy hh:ss:mm a to mm/dd/yyyy

I have a date dimesnion in universe which is of the format mm/dd/yyyy hh:mm:ss a, I’d like to convert the dimension to mm/dd/yyyy. I use sql server as backend. tried using Datepart(), is ther other function which gives me to mm/dd/yyyy rnola (BOB member since 2006-03-26)

---

rimpa (BOB member since 2008-04-14)