topic Reminder before 6 months using lucene date range in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/reminder-before-6-months-using-lucene-date-range/m-p/237820#M190950 <HTML><HEAD></HEAD><BODY><SPAN>Hello guys,</SPAN><BR /><BR /><SPAN>I am having a custom property for passport expiry date. "</SPAN><STRONG>custom<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />assport_end_date</STRONG><SPAN>".</SPAN><BR /><BR /><SPAN>I am writing a scheduled action that searches the full repository and find passport documents which will expire after six months.</SPAN><BR /><BR /><SPAN>I have written following date range query, but not getting the required result.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>@custom\:passport_end_date :$[luceneDateRange(today, \"P6M\")]<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>How can I calculate </SPAN><STRONG>custom<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />assport_end_date</STRONG><SPAN> here?</SPAN><BR /><BR /><SPAN>I have referred </SPAN><A href="http://wiki.alfresco.com/wiki/Scheduled_Actions" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Scheduled_Actions</A><SPAN> and </SPAN><A href="http://wiki.alfresco.com/wiki/Search" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Search</A><SPAN> but didn't get</SPAN><BR /><SPAN>required output.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Nikesh</SPAN></BODY></HTML> Wed, 22 Jul 2009 11:54:29 GMT nikes 2009-07-22T11:54:29Z Reminder before 6 months using lucene date range https://connect.hyland.com/t5/alfresco-archive/reminder-before-6-months-using-lucene-date-range/m-p/237820#M190950 Hello guys,I am having a custom property for passport expiry date. "custom<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />assport_end_date".I am writing a scheduled action that searches the full repository and find passport documents which will expire after six months.I have written following date range query, but not getting the required resul Wed, 22 Jul 2009 11:54:29 GMT https://connect.hyland.com/t5/alfresco-archive/reminder-before-6-months-using-lucene-date-range/m-p/237820#M190950 nikes 2009-07-22T11:54:29Z Re: Reminder before 6 months using lucene date range https://connect.hyland.com/t5/alfresco-archive/reminder-before-6-months-using-lucene-date-range/m-p/237821#M190951 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>1/ The link to scheduled action you pointed out shows the use of "{ … }" instead of "[ … ]".</SPAN><BR /><SPAN>2/ it seems you have a space that should not be here</SPAN><BR /><BR /><BR /><SPAN>Try : </SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />@custom\:passport_end_date:${luceneDateRange(today, \"P6M\")}<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 23 Jul 2009 07:03:01 GMT https://connect.hyland.com/t5/alfresco-archive/reminder-before-6-months-using-lucene-date-range/m-p/237821#M190951 jayjayecl 2009-07-23T07:03:01Z