When comparing dates in a FullTextSqlQuery remember the date literal must be surrounded by single quotes and formatted in YYYY-MM-DD format.
Example:
SELECT Title,FileExtension,ContentType,Path FROM SCOPE() WHERE owsStartDate > '2003-12-01'
Hello, my name is Pedro Mateus and 'Ponto de Partilha' is 'SharePoint' roughly translated to Portuguese. Since i started with SharePoint and .NET i have found great resources that helped me, this is a way to give to the community something back in return, and keep some sort of a log of stuff i do.
SELECT Title,FileExtension,ContentType,Path FROM SCOPE() WHERE owsStartDate > '2003-12-01'
1 comment:
Very useful for me. Thank you.
Post a Comment