Hi All,

I need to filter the dates in my table according to shipdate field and display that data in a form. This is the code I have done so far to test the situation.( table is open in current work area)

„h Set Century On
„h MyDate = Date(2003,12,22)
„h Set filter to shipdate <= Mydate
„h Browse

My results
I get all shipdate <= Mydate PLUS ship dates due in next year (2004). Looks like it checks only the month and the date but not the year. How do I fix this problem. I¡¦m using VFP7 SP1

Please Help !!

TIA

- Jeana -