Hi All,

I have alway known that there is an issue when it comes to dates format. Here is what my ASP page does. It contains a text box where users will input their birthday date in mm/dd/yy format. The datatype of the date field in SQL is "datetime." The data looks fine after I have submitted the date into the database(ie. 02/16/88).

Now my question is, if I were to create another ASP page where I enter a birthday to search for, let say birthday >= to 02/16/88, how would I code that? Can I simply do something like:

Select from databasename where birthday_field >= "birthday_search_input"

THanks in advance for your help.

Leon

Leon,

http://vyaskn.tripod.com/searching_date_time_values.htm -- you might
want to read this.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com