Hi Sambit! Do not forget that JCR-SQL and JCR-SQL2 are just "JCR-like" languages, not fully compatible SQL dialects.
See https://wiki.magnolia-cms.com/display/WIKI/JCR+Query+Cheat+Sheet - the last one is your case. You have to specify also the time part of the datetime, i.e. something like [code]select * from [nt:base] where ISDESCENDANTNODE([/MyData/]) and cast(r_date as date) > cast('2014-11-12T00:00:00.000+02:00' as date) and cast(r_date as date) > cast('2014-11-18T00:00:00.000+02:00' as date)[/code] Regards, Jozef. -- 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]> ----------------------------------------------------------------
