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!
You could try adding a Rank calculation based on the date, then filtering the report for Rank = 1
MF.