https://connect.hyland.com/t5/alfresco-forum/i-need-to-create-a-date-range-query-on-cutom-field-of-a-smart/m-p/103455#M29444 <DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>Hello everyone,</P><P>I'm trying to query cutom field on a smart folder (alfresco 5.2). the field is called mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriod of type text with a regex format YYYYMM (values can be 201912 or 202003...etc)</P><P>The aim is to show documents of last two months of the field mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriod, last try without success :</P><P>"query" : "=mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriode:[NOW/YEAR-2MONTHS + NOW/MONTH-2MONTHS TO NOW/YEAR + NOW/MONTH]"</P><P>this static query works :</P><P>"query" : "=mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriode:[202001 TO 202003]"</P><SPAN class="lia-message-unread">Which is the correct syntax to make it dynamic inside the smart folder with current date (NOW)<BR /></SPAN><P>Regards</P></DIV></DIV> Tue, 24 Mar 2020 17:12:17 GMT tyuton 2020-03-24T17:12:17Z https://connect.hyland.com/t5/alfresco-forum/i-need-to-create-a-date-range-query-on-cutom-field-of-a-smart/m-p/103455#M29444 <DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>Hello everyone,</P><P>I'm trying to query cutom field on a smart folder (alfresco 5.2). the field is called mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriod of type text with a regex format YYYYMM (values can be 201912 or 202003...etc)</P><P>The aim is to show documents of last two months of the field mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriod, last try without success :</P><P>"query" : "=mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriode:[NOW/YEAR-2MONTHS + NOW/MONTH-2MONTHS TO NOW/YEAR + NOW/MONTH]"</P><P>this static query works :</P><P>"query" : "=mymodel<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />eriode:[202001 TO 202003]"</P><SPAN class="lia-message-unread">Which is the correct syntax to make it dynamic inside the smart folder with current date (NOW)<BR /></SPAN><P>Regards</P></DIV></DIV> Tue, 24 Mar 2020 17:12:17 GMT https://connect.hyland.com/t5/alfresco-forum/i-need-to-create-a-date-range-query-on-cutom-field-of-a-smart/m-p/103455#M29444 tyuton 2020-03-24T17:12:17Z