Skip to Content
0
Jan 10, 2014 at 06:31 AM

Could not get last 3 month's data

33 Views

Hi,

"

d.MONTH IN (EXTRACT_MONTH(CURRENT_DATE) - 2,EXTRACT_MONTH(CURRENT_DATE) - 1,EXTRACT_MONTH(CURRENT_DATE) + 0)

"

The above code now gives only current month's data.

We have 3 Months calculation view, where it shows 3 month's data(including the current month). It was showing expected data since December month. Since, it's the New year, it's not picking up last years' last 2 Months data and shows only current Month's data.

How could I correct my code here? Kindly suggest.

Regards,

Antony Jerald.