Thanks, Ricardo! But for me your example is not enough. I need to filter not by fixed date, but for dynamic criteria - current date - 5 days ... How is it possible? Maybe I should do it by 2 steps: 1) set target date (current date - 5 days) as value, 2) use this target date (fixed value) as a filter criteria. Ok, but for this - how is it possible to define my target date = current date - 5 days? Thanks beforehand Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/using-XWQL-with-additional-search-criteri… Sent from the XWiki- Users mailing list archive at Nabble.com.

I checked this example and your script - it is not correct, because you compare separately year, month and day of document with current date - year, month and day-100. But if, for example now is 02 january, your script give uncorrect result, becase I also should change year and month (and year), then I want to get date BEFORE 100 days of 02 january. Need to make arithmetical operations with dates and these operations should consider also possible transitions of month and year when day changed ... In any case - thanks! I found the answer - need to use special velocity object $datetool Example: #set ($d = 5) - days interval which I need #set ($ms = $d * 24 * 60 * 60 * 1000) - Calculating internal in Milliseconds #set ($calendar = $datetool.getCalendar()) #set ($currentTime = $calendar.getTimeInMillis()) #set ($targetTime = $currentTime - $ms) #set ($void = $calendar.setTimeInMillis($targetTime)) #set ($targetDate = $calendar.getTime()) #set ($targetYear = $datetool.getYear($targetDate)) :get year of a date = currentdate - 5 days #set ($targetMonth = $datetool.getMonth($targetDate) + 1) :get month of a date = currentdate - 5 days #set ($targetDay = $datetool.getDay($targetDate)) :get day of a date = currentdate - 5 days and after this, in a hql searching, I can compare this year, month, and day with documents year, month and day ... -- View this message in context: http://xwiki.475771.n2.nabble.com/using-XWQL-with-additional-search-criteri… Sent from the XWiki- Users mailing list archive at Nabble.com.

Hi Sergiu! I played before with jodatime. It have some problems ... For example, I tried to use example script from plugin home page (it can be usefull in my situation) and this script doesn't working: #set($formatter = $xwiki.jodatime.getDateTimeFormatterForPattern('yyyy.MM.dd')) #set($myBirthday = $formatter.parseDateTime('2007.11.25')) #set($daysLeft = $myBirthday.minus($now.millis)) $daysLeft.getDayOfYear() days left till my birthday! Also joda time is badly described - for all these reasons I used datetool. About query ... Better for me - XWQL, but all my tryings to use any dates in XWQL gives some errors (most of all - java errors in a translation from XWQL to hql ...). I am not a professional in a XWQL and HQL (I am not sure - this is my error or bug), and Ricardo gave working example of using HQL - for this reason I used ready query example. If you can give working example of using dates in a XWQL - will be great! Also I tried examples from here: http://dev.xwiki.org/xwiki/bin/view/DesignArchive/XWikiQueryLanguageSpecifi… (second script) - but give me error. -- View this message in context: http://xwiki.475771.n2.nabble.com/using-XWQL-with-additional-search-criteri… Sent from the XWiki- Users mailing list archive at Nabble.com.

Hi! Eugen Colesnicov wrote: You are completely right: it is clearly stated in the example. They talked only about "current" day, week and month. Sorry about being "too fast" and don't think enough before posting! -- Ricardo Rodríguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems