>>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
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao