How limit loading data in script

[canmarroig]

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?

[Gysbert_Wassenaar · Accepted solution]

Try WHERE MonthStart(DATA) = MonthStart(Today(),-1)

[balar025]

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?