BusinessObjects Board

How can I remove the Time Stamp from a Date on sql server

building semantic layer
#1

Hi all
This is how it looks like on the server
5/25/2005 12:00:00

after using this
code convert(char(12),AWAR.dbo.tblWARReportDetail.Period,101)

it gives me the format i wanted 2/25/2005 but on the prompt it is not sorted properly.

How can i remove the time stamp and have the date appear sorted at the prompt. thanks

Eljo :us: (BOB member since 2005-08-10)

Date Prompt Format
#2

Check out this FAQ from Mark P, which may help.

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

Thanks nick
i tried that cast(convert(char(12),Period,23) as datetime)

it is parsing ok. but the time stamp remains on the LOV . I am using prompt and how can I just have the sorted date to choose from the prompt. thanks
Eljo

Eljo :us: (BOB member since 2005-08-10)

#4

the following link might help you

http://homepage.mac.com/rmetzk/PDF_Files/DateLOVs.pdf

Thanks,

Sree Konduri (BOB member since 2005-07-14)

#5

thansk Guptha

How can i convert this code to work for sql server


Select DATEOBJ from
( select distinct 
 to_char(customer.entry_date,'MM/DD/YYYY') as DATEOBJ
from 
   customer
)
 order by to_date(DATEOBJ,'MM/DD/YYYY')

thanks

Eljo :us: (BOB member since 2005-08-10)