searching between 2 date fields with where in cfquery

i have a table that has two date fields (dateinx and dateoutx) and i need to find all the results for todays date that both fall between and on that date for a given customer: cID. database is msSQL2005 cfserver is 7 if todays date is 12/2/2012examples of vialable entries: -

Re: searching between 2 date fields with where in cfquery

i have a table that has two date fields (dateinx and dateoutx) and i need to find all the results for todays date that both fall between and on that date for a given customer: cID. This should be fairly simple to add to your existing query... AND GETDATE() BETWEEN dateinx AND dateoutx