Lucene search date range MIN, NOW not working

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

shikarishambu

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 below

if (((createdFrom == "") || (createdFrom == null)) && ((createdTo != "") && (createdTo != null)))
{
   query = '+@cm\\:created:\[' + MIN + ' TO ' + fnToISO(createdTo) +  '] ' + query;
}

if ((createdFrom != "") && (createdFrom != null) && ((createdTo == "") || (createdTo == null)))
{
   query = '+@cm\\:created:\[' + fnToISO(createdFrom) + ' TO ' + NOW +  '] ' + query;
}
‍‍‍‍‍‍‍‍‍‍

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.

function fnToISO(dt) { 
   var nDate = new Date(dt);
   return nDate.format("isoDateTime");
    }‍‍‍‍

pcorliss

I had difficulty with the date range searching until I started using full date strings including time. Try the following format.

YYYYMMDDTHH:MMS.000
example: 20100201T00:00S.000