I've created a front end search page in Silverlight 4 for SharePoint Search. Currently we are using WSS 3.0 + Search Server Express 2008 (v 126.96.36.19921). The page interacts with the MOSS version of the search web service at: <site
The reason for this approach is the unique way the requirements specify the look and behavior of the results. The built-in Search Center page or web parts will not satisfy these requirements.
We are going into production but I still cannot figure out how to search against my custom managed properties that are of Type DateTime. If I cannot get this to work, it is a showstopper.
I've tried numerous variations on the SQL Syntax and cannot get it to work. I know the error is in the date portion of the WHERE clause since I can remove it and searches work fine.
Here is a working query:
SELECT Size, Rank, Path, Title, Description, Write, RequestSubmittedDate, DocumentType, RequestPromisedDate, ProblemDescription, DatePublished, RequestOwner, RequestingDepartment, DocumentAuthor, ProjectNumber, ProjectDescription, RequestStatus
FROM scope() WHERE CONTAINS ('"nmr"') ORDER BY "Rank" DESC
yet if I try to use a date literal in the WHERE clause as in the following query modification, I get the "malformed"
View Complete Post