>>ADS has a Time datatype, which is internally stored as the number of milliseconds since midnight in a 4-byte integer.
>
>OK the same query, but you should find the right functions for converting:
>

>SELECT YourTable.*;
>       FROM YourTable;
>INNER JOIN (SELECT Sh, MAX(ConvertDateToISO(DateSaved)+' '+ConvertTimeToString(TimeSaved)) AS DateTimeSaved;
>                   FROM YourTable;
>            GROUP BY Sh) Tbl1;
>ON YourTable.Sh = Tbl1.Sh AND;
>   ConvertDateToISO(YourTable.DateSaved)+' '+ConvertTimeToString(YourTable.TimeSaved) = Tbl1.DateTimeSaved
>

>
>Where ConvertDateToISO() should convert your Date to string with folwong format "YYYYMMDD" and
> ConvertTimeToString() should convert Time to string no matter what format it is, just make sure that 12:01 PM is bigger than 12:01 AM it could be:
>"18:20", "1820", "66000" (that is 18*3600 + 20*60)

Hi Borislav,

Please check my suggestion. It may be slower, but no conversions are needed. First we filter the maximum date, then the maximum time for that date.