Hi guys

I have two derived dates in my IDT as below:

Date 1:

TRUNC(DIM_DATE.CALENDAR_DATE,'MONTH')

Date 2:

MAX(DIM_DATE.PAYMENT_DATE)

I need to do a 'month between' for these two dates but IDT gives an error saying 'Not a single group by' function... any ideas how to resolve this?