topic Lucene date syntax in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lucene-date-syntax/m-p/164939#M118657 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco,</SPAN><BR /><BR /><SPAN>I'm looking for the correct way to retrieve documents modified between day A and day B. This will be a Lucene search but the syntax is confusing. How should the search be formatted? On the </SPAN><A href="http://wiki.alfresco.com/wiki/Search#Range_Queries" rel="nofollow noopener noreferrer">wiki</A><SPAN> it says that the date is ignored (but it needs to be specified or not?) the forum tells a different story where sometimes the date is added, sometimes not.</SPAN><BR /><BR /><SPAN>The following search works in de node browser but </SPAN><STRONG>always</STRONG><SPAN> returns the same 12 documents, even if you specify "something" instead of a date. What am I missing?</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>@cm\:modified\:"2007-05-01 TO 2007-05-20"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Tue, 13 May 2008 10:46:49 GMT simon 2008-05-13T10:46:49Z Lucene date syntax https://connect.hyland.com/t5/alfresco-archive/lucene-date-syntax/m-p/164939#M118657 Alfresco,I'm looking for the correct way to retrieve documents modified between day A and day B. This will be a Lucene search but the syntax is confusing. How should the search be formatted? On the wiki it says that the date is ignored (but it needs to be specified or not?) the forum tells a differe Tue, 13 May 2008 10:46:49 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-date-syntax/m-p/164939#M118657 simon 2008-05-13T10:46:49Z Re: Lucene date syntax https://connect.hyland.com/t5/alfresco-archive/lucene-date-syntax/m-p/164940#M118658 <HTML><HEAD></HEAD><BODY><SPAN>For future reference, this seems to work:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>@cm\:modified:[2007-05-01T00:00:00 TO 2007-05-20T00:00:00]<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>I don't know but it seems you </SPAN><STRONG>need</STRONG><SPAN> the time value even if it doesn't work. You </SPAN><STRONG>need</STRONG><SPAN> the first slash after the cm but you </SPAN><STRONG>can not</STRONG><SPAN> use a slash after modified.</SPAN><BR /><BR /><SPAN>If you want to use this query in JavaScript you'll have to add a second slash after cm like this:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>@cm\\:modified:[2007-05-01T00:00:00 TO 2007-05-20T00:00:00]<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 13 May 2008 11:04:06 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-date-syntax/m-p/164940#M118658 simon 2008-05-13T11:04:06Z