Skip to Content
0

Complicated IDT calculation

Dec 19, 2016 at 05:54 PM

31

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Dec 20, 2016 at 10:27 AM
0
Share
10 |10000 characters needed characters left characters exceeded