Thanks for valuable reply
but unable to find is coming fromDate because it should change into from_Date by entitymodel delegator.findByAndCache("EmplLeave", UtilMisc.toMap("month(fromDate)", submitmonth,"year(fromDate)",submityear), null); Regards Anurag -- View this message in context: http://n4.nabble.com/How-can-i-create-sql-query-using-delegator-tp1858040p1873104.html Sent from the OFBiz - User mailing list archive at Nabble.com.