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)