I have a strange issue: if I search for documents that have not been modified for 2 years, I will still find documents that have been modified in 2014. Obviously, this is unexpected and unwanted.

I've used advanced search for this, resulting in the following query: Write<=1-1-2012

Any ideas what may cause this behavior? Thank you for your help!

Edit: I'm using sharepoint 2010 by the way...

  • I think you need to add the date in this format: yyyy-MM-ddTHH:mm:ssZ – Robert Lindgren Oct 1 '14 at 9:15
  • Thank you for your quick reply! I just tried that, and unfortunately ended up with the same (wrong) search results... – Rostam Oct 1 '14 at 9:17
  • I do not recognize the Managed Property Write, shoud you not use Modified? – Robert Lindgren Oct 1 '14 at 9:19
  • You mean Modified<=2012-1-1? The first hit is a document created in 2013, so this isn't working as expected either :-/ – Rostam Oct 1 '14 at 9:26
  • You should still use correct query format – Robert Lindgren Oct 1 '14 at 9:54

You need to write the query as


Here is a good reference for search keywords for SharePoint 2010.

  • Thank you for the suggestion and the reference! Unfortunately, it still shows the wrong search results... :-/ – Rostam Oct 1 '14 at 13:49
  • did you try to directly type this into the default search box instead of doing it into the advanced search ? – Vipul Kelkar Oct 1 '14 at 14:11
  • Yes I did, any other ideas? – Rostam Oct 1 '14 at 14:17
  • I just tested this in my environment and it works for me. Make sure you do not have any spaces in the query and put the date in quotes. Also, might sound naive, but are you sure there are documents available for the criteria you are searching on ? – Vipul Kelkar Oct 1 '14 at 14:29
  • Thank you for your help. Most results in the search result match what I'm looking for, but quite a few do not. I guess the search query is correct, so that would suggest something underwater is broke..? – Rostam Oct 2 '14 at 7:16

I guess date/time should be UTC in ISO formatted.



Date with time YYYY-MM-DDThh:mm:ssZ:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.