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