We have a two forms, one that contains valid dates/publication that the user can select, the other contains data including a publication and one of the selected dates.

For an admin report I want to show the maximum date that's configured as well as the maximum date that the users have booked to.

The reason for the report is so that the administrator can see when they need to start configuring new dates for any publication.

Is this possible, as I haven't been able to find a max function in the pivot reports, only count/sum/avg/etc.