Steven Wouters´s Blog

I have some bizare results when i query the database.
This is the query :

"SELECT \"DAV:href\", \"DAV:displayname\", \"DAV:contentclass\", \"urn:schemas-microsoft-com:office:office#ows_Publicatiedatum\" FROM ( TABLE Portal_Content..Scope() UNION ALL TABLE Non_Portal_Content..Scope() ) WHERE (\"urn:sch
emas.microsoft.com:sharepoint:portal:isdocument\" = 1) AND (\"urn:schemas-microsoft-com:office:office#ows_Publicatiedatum\" > '2006/3/20') AND (\"urn:schemas-microsoft-com:office:office#ows_Publicatiedatum\" <= '2006/3/21') "

Although there are documents that match the criteria, no documents are found. ... There seems to be something on with searching on date fields! Has it something to do with GMT? I haven´t found a solution yet.