Hi!
Just to add on, if u want to do a select from date1 to date2, I think its advisable to store your dates in the following
string format in your database : yyyymmdd, eg, 19990101 and 20001212. So, to search for dates between 1/1/1999 and 12/12/2000, all you have to do is to search for strings between 19990101 to 20001212.
It'll also save you some time since all you need to do is to concatenante the year, month and day fields to produce the search string.
Any comments anyone?