>Try

WHERE YEAR(Pickdetail.EditDate) = 2006

Sergey,

This was the first thing I tried but since this is a remote view using an ODBC connection to connect to MSQ SQL 6.5, I get the error:

"'YEAR' is not a recognized built in function."

When this didn't work, tried using the SQL DATEPART command and got it to work but after I save it and then try to reload the view into the View Designer, I get the error described in the previous e-mail.

I can first create an unfiltered remote view and then create a filtered local view on the remote view using the standard VFP YEAR(), MONTH(), DATE() commands but this seems to be over-kill to have to create two views ... I'm hoping there's a way to do it in the remote view.

Thanks,
Robert Wright

Thanks,
Robert