i need to do an ADO search on the "effective date" property. This is
what i have got and it didn't work.

"SELECT ""DAV:displayname"" AS DisplayName, ""DAV:href"" AS
HRef, ""urn:schemas-microsoft-com:office:office#Title"" AS Title, "
&_

" ""urn:schemas.microsoft.com:fulltextqueryinfo:description""
AS Description, ""urn:schemas.microsoft.com:fulltextqueryinfo:rank""
AS RANK, " & _
" CAST(""DAV:getlastmodified"" AS DATE) AS
LastModified, CAST(""urn:schemas-microsoft-com:office:office#Product
Effective Date"" as DATE) as effectiveDate" & _
" from scope('deep traversal
of ""/phoenix/documents""') where ""urn:schemas-microsoft-
com:office:office#Product Effective Date"" = 12/31/2001"