Microsoft Indexing Service query by date [RESOLVED]

[lleemon]

Set up the Microsoft Indexing Service on our server and created a asp.net page to query. We got it working except for quering the results by a start date and end date.

Has anyone else found if you can query by 'Access'?

My sql is:
SELECT doctitle, filename, rank, access
FROM scope()
WHERE CONTAINS('myterm')
AND (Access > '01/09/05' AND Access < '02/09/05')
ORDER BY Rank DESC

If I take out the AND line it works great but the dates just don't seem to catch the right files. Anyone have any good insight on this?

Thanks.