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

That will include values from next month 1st.
Also Date function accept parameters that way:
DATE(year, month, day), not DATE(day, month, year) :-)