hiw to retrieve the latest datetime record

[MariusD]

Hi,

I am trying to retrieve the latest record from a table (the record with the highest datetime). In TSQL, I can do select top 1 * from x, order by [date] desc - how do I translate that into a filter?

Thanks!

[MFGF]

You could try adding a Rank calculation based on the date, then filtering the report for Rank = 1

MF.