I have a simple AO which is HistoricalData and it has 2 columns Date and Count. How can I get Max date programatically from it. I am trying with
ao.findWithSQL(HistoricalData.class, "DATE", "select max(DATE) from HISTORICALDATA", null);