Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Ado search

  Asked By: Abhishek    Date: Apr 30    Category: Sharepoint    Views: 846

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"



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Ado search Or get search suggestion and latest updates.