In my data repo i have a String property which have store date as String in 'dd/MM/YYYY hh:mm:ss' format. I want an sql query which will give me all the node for which that property value as date fall in between two date.
I am trying with below query but its not working. select * from nt:base where jcr:path like '/MyData/%' and CAST(r_date as DATE) between 2014-11-12 and 2014-11-18 But its showing error as ' Encounter "r_date" at line1: Was expecting ")"... Please anyone have any idea for this kind of query please share. -- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=b34cbea9-2d14-4263-8e6a-ad518b8c79e4 ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
