https://connect.hyland.com/t5/nuxeo-forum/date-comparison-in-nxql-query/m-p/318760#M5761 <P>Hi</P> <P>i m trying to build dynamic content based on dates comparisons :</P> <P>I can either use smart folders in order to build a NXQL query that must contain a static part (eg : validation_date &gt; current_date). Unfortunately, there is no current_date constant in NXQL (and that is a pity)</P> <P>On the other hand, i could build a content view "à la" smart folder (just like "Nuxeo Studio Rocks – Part 1 – Queues (aka Smart Folders)" but I cannot find the right EL syntax for it (eg : validation_date &gt; #{searched_validation_date} )</P> <P>Any clue ?</P> Tue, 14 Oct 2014 07:52:41 GMT pibou_Bouvret 2014-10-14T07:52:41Z https://connect.hyland.com/t5/nuxeo-forum/date-comparison-in-nxql-query/m-p/318760#M5761 <P>Hi</P> <P>i m trying to build dynamic content based on dates comparisons :</P> <P>I can either use smart folders in order to build a NXQL query that must contain a static part (eg : validation_date &gt; current_date). Unfortunately, there is no current_date constant in NXQL (and that is a pity)</P> <P>On the other hand, i could build a content view "à la" smart folder (just like "Nuxeo Studio Rocks – Part 1 – Queues (aka Smart Folders)" but I cannot find the right EL syntax for it (eg : validation_date &gt; #{searched_validation_date} )</P> <P>Any clue ?</P> Tue, 14 Oct 2014 07:52:41 GMT https://connect.hyland.com/t5/nuxeo-forum/date-comparison-in-nxql-query/m-p/318760#M5761 pibou_Bouvret 2014-10-14T07:52:41Z