Hi 2807661, I took out current-group() and used the function on TRANSACTION_DATE as <?xdofx:to_char(max(TRANSACTION_DATE), 'dd-mm-yy')?> Strangely it is working with the exception that it always increment one day to all dates. Thanks, Anwar

Hi 2807661, I tried xdofx way too but it didn't work. It keeps returning null. I would try to move the logic to data model. Thanks, Anwar.

I could but I would have to modify DM heavily as it is a very complex report. So as a workaround I took the route of grouping in template. I wonder why the function doesn't return the output in canonical format. The value returned by maximum function is correct but not in correct format.