Hi,
Iam facing a problem in creating a sub query in Criteria.

What i want. i want to call a DAO where iam passing 'effective Date' as well as a parameter to get the filtered record means i want to fire a criteria query where i will get some records and now on those records i want to get the max or latest of record based on the 'effective date' passed.
For e.g.

Called
A(effective date)
{
criteria query
}

suppose 10 records are found with random effective dates in it and the effective date passed is 10th jan 2010 then it should return that particular record which is less than the effect. date provided and Max of effective date (in those 10 records).
thank you