system
May 12, 2008, 7:43am
#1
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
May 12, 2008, 12:47pm
#2
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
May 12, 2008, 4:40pm
#3
If you going against SQL Server,
Try looking at this thread
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)