Is it possible to request only data that is from a given period?

[WuCOng]

I have a table that has the field &quot;date_created&quot;. I want to be able to pull data that was only created between date X and date Y on to the screen via ASP. The user is supposed to choose the from and to dates via two <select> lists.

Can it be done?

 

[shaddow]

If the table is in ACCESS

querry=&quot;select * from MyTable where date_created between #&quot;&date_start&&quot;# and #&quot;&date_end&&quot;#&quot;

If the table is in SQL

querry=&quot;select * from MyTable where date_created between '&quot;&date_start&&quot;' and '&quot;&date_end&&quot;'&quot;

Hope this helps u. ________

George