topic Lucene search date range MIN, NOW not working in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lucene-search-date-range-min-now-not-working/m-p/219163#M172293 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use the MIN and NOW functions that are shown in the Search API syntax as part of my custom search webscript. However, I can't seem to get it working. How do I specify default lower and upperbounds for date ranges in search?</SPAN><BR /><BR /><SPAN>My webscript snippet is shown below</SPAN><BR /><PRE class="language-none line-numbers"><CODE>if (((createdFrom == "") || (createdFrom == null)) &amp;&amp; ((createdTo != "") &amp;&amp; (createdTo != null)))<BR />{<BR />&nbsp;&nbsp;&nbsp;query = '+@cm\\:created:\[' + MIN + ' TO ' + fnToISO(createdTo) +&nbsp; '] ' + query;<BR />}<BR /><BR />if ((createdFrom != "") &amp;&amp; (createdFrom != null) &amp;&amp; ((createdTo == "") || (createdTo == null)))<BR />{<BR />&nbsp;&nbsp;&nbsp;query = '+@cm\\:created:\[' + fnToISO(createdFrom) + ' TO ' + NOW +&nbsp; '] ' + query;<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I tried to replace MIN with fnToISO('1/1/1900'), that works. However, replacing NOW with fnToISO(), results in an error. The function fnToISO is shown below.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>function fnToISO(dt) { <BR />&nbsp;&nbsp;&nbsp;var nDate = new Date(dt);<BR />&nbsp;&nbsp;&nbsp;return nDate.format("isoDateTime");<BR />&nbsp;&nbsp;&nbsp; }<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 01 Mar 2010 17:25:21 GMT shikarishambu 2010-03-01T17:25:21Z Lucene search date range MIN, NOW not working https://connect.hyland.com/t5/alfresco-archive/lucene-search-date-range-min-now-not-working/m-p/219163#M172293 I am trying to use the MIN and NOW functions that are shown in the Search API syntax as part of my custom search webscript. However, I can't seem to get it working. How do I specify default lower and upperbounds for date ranges in search?My webscript snippet is shown belowif (((createdFrom == "") || Mon, 01 Mar 2010 17:25:21 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-date-range-min-now-not-working/m-p/219163#M172293 shikarishambu 2010-03-01T17:25:21Z Re: Lucene search date range MIN, NOW not working https://connect.hyland.com/t5/alfresco-archive/lucene-search-date-range-min-now-not-working/m-p/219164#M172294 <HTML><HEAD></HEAD><BODY><SPAN>I had difficulty with the date range searching until I started using full date strings including time. Try the following format.</SPAN><BR /><BR /><SPAN>YYYYMMDDTHH:MM<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />S.000</SPAN><BR /><SPAN>example: 20100201T00:00<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />S.000</SPAN></BODY></HTML> Wed, 03 Mar 2010 23:31:09 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-date-range-min-now-not-working/m-p/219164#M172294 pcorliss 2010-03-03T23:31:09Z