>>Say, you pass month and year as two numbers
>>
>>Select * from myTable where ExitDate between
>>date(1,PassedMonth, PassedYear) and gomonth(date(1,PassedMonth, PassedYear),1)
>>into cursor curResults nofilter
>>
>>If you need it as a filter then
>>
>>SET FILTER TO between(ExitDate, date(1,PassedMonth, PassedYear), gomonth(date(1,PassedMonth, PassedYear),1) )
>>
>>assuming you may have an index on the date field.
>
>That will include values from next month 1st.
>Also Date function accept parameters that way:
>DATE(year, month, day), not DATE(day, month, year) :-)
Good point. I was somehow thinking SQL Server and wanted to write
>= and <
but forgot at some point.
Still the point is to use direct DATE comparision to make this query sargable as opposite to your and Tore's suggestions that would make this query non-sargable.
If it's not broken, fix it until it is.
My Blog