[xwiki-users] Query a date field?

Hi everyone, having a small problem on an HQL query (and hope someone's managed to get this working before) NOTE: $dtDateToCompare is yesturdays date, generated with groovy select obj.name from BaseObject obj, XWikiDocument doc, StringProperty propnrd where obj.className='XWiki.clickClass' and obj.name<>'XWiki.clickClassTemplate' and obj.name not like('%/%') and doc.fullName=obj.name and propnrd.id.id=obj.id and propnrd.id.name='clickDateAssign' and propnrd.value < '${dtDateToCompare}' order by obj.name asc This works if I use the modified date property of the document (as a test); but not for a custom date property (propnrd.id.name='clickDateAssign' is a date property of the class). Anybody do something similar and can share some pointers? Using MySQL if that makes any difference