>Dear All,
>I have a table with a date field with different date of course
>will it be possible to filter a specific month from the date field
>table structure
>
>Idnumber n(10)
>Employee c(40)
>entrancedate d(8)
>exitdate d(8)
>
>I want to filter for the month of November or any month the the exit date of the employee
>Thank you
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.
If it's not broken, fix it until it is.
My Blog