How Do I get record set for before certain date

[choohean]

I have created a database that store certain value and date as well at the same time! How do I get record set which is before certain date?

Please give me a hand!

Thanks for your kindness!!

 

[bperry]

Usually, you have to Convert() the date to strip off the time. For example, convert(varchar(20),MyDate(),112) gives you yyyymmdd. So could do something like this:

Select * from MyTable Where
convert(varchar(8),MyDate1(),112) <
convert(varchar(8),MyDate2(),112)



This guy has a good date/time page. Check it out.

http://tlbroadbent.home.attbi.com/sql_and_access/sql_server_datetime.htm

Terry