This is the query:
" select dbo from EmpWorkDiaryEntriesDBO dbo"
+ "lef join fetch dbo.empWorkDiaryEntriesDetailsDBOSet dbos"
+ "where dbo.recordStatus='A' and dbo.erpWorkEntryDate between (:startDate)
and (:endDate) order by erpWorkEntryDate ASC ";
And this is the error
getting eror expecting EOF, found ')'