Hi, i need to limit data loading only for current year on the previous month, for instance today I need only August data
I've tried to set a where condition:
where NUM(month(DATA)) <= NUM(month(today())-1); but this set on 8 (August) data also in 2016, 2015, ecc.
Can you help me?
Try WHERE MonthStart(DATA) = MonthStart(Today(),-1)
As i understand from query is ,
You need full data for previous years but for current year, you want only current month data.
Is this the case?
Retrieving data ...