I have searched this forum and various other resources like FAQ on this and other related sites but I couldn't find what i'm looking for. I appriciate if someone could help me out...

I need a date range search for a travel site. When a user searches for a desired departure date, I need to display all results that the departure day falls inbetween season dates. In the database, two fields are alocated to season dates, SeasonStart and SeasonEnd date.

All records have a SeasonStart and SeasonEnd date, so when a user searches for a departure day, all records that have a departure day that falls inbetween SeasonStart and SeasonEnd date need to be displayed.

I hope this is not too confusing. Thanx in advance.

Have you checked the FAQ noted in my signature in the section "Dates" and "Searching"?

I know there have been threads with this question and suggestions posted. I'm unable to access the notes on my other computer to give you specific thread references.

You could also try searching the FAQ for "range" or "date range" here in the GT forum.

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/