>>>I have a character field in which we store dates (format is 01/01/2000) of a persons visit. I would like to select only those that are no further back then todays date. I am using the getdate() function to determine the day. However I cannot get the results to come back correctly.
>>>
>>>
>>>what i am looking for
>>>
>>>select * from mytable where ddate >( getdate() - 6 months)
>>
>>You might want to try...
>>
>>select * from mytable where covert(datetime, ddate) > (getdate()-180)
>>
>>BOb
>
>Another way to do it is use the DATEDIFF() function.
>
>select * from mytable where datediff(m,ddate, getdate()) <= 6

Except that he said his date field was char(), or will this do an implict conversion?