Selecting the last date from a group of columns in a crosstab report

[sprog]

I have a cross tab report with fortnightly pay dates running across the top, as column headers.

I need to pluck the very last date (from the last column) out and put it into the details section.

When I refresh every fortnight another column will be added and this will be date required.

Thanks