I need to create a date range query on cutom field of a smart folder, which syntax ?

[tyuton]

Hello everyone,

I'm trying to query cutom field on a smart folder (alfresco 5.2). the field is called mymodeleriod of type text with a regex format YYYYMM (values can be 201912 or 202003...etc)

The aim is to show documents of last two months of the field mymodeleriod, last try without success :

"query" : "=mymodeleriode:[NOW/YEAR-2MONTHS + NOW/MONTH-2MONTHS TO NOW/YEAR + NOW/MONTH]"

this static query works :

"query" : "=mymodeleriode:[202001 TO 202003]"

Which is the correct syntax to make it dynamic inside the smart folder with current date (NOW)

Regards

[tyuton]

Hello everyone,

I'm trying to query cutom field on a smart folder (alfresco 5.2). the field is called mymodeleriod of type text with a regex format YYYYMM (values can be 201912 or 202003...etc)

The aim is to show documents of last two months of the field mymodeleriod, last try without success :

"query" : "=mymodeleriode:[NOW/YEAR-2MONTHS + NOW/MONTH-2MONTHS TO NOW/YEAR + NOW/MONTH]"

this static query works :

"query" : "=mymodeleriode:[202001 TO 202003]"

Which is the correct syntax to make it dynamic inside the smart folder with current date (NOW)

Regards