>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.