Last FULL month 1

[cpagano]

I want a query that always gathers its data for the last FULL month..
Ive tried this ..


where adm_ts >= DATEADD(month,-1,GETDATE())

But it seems to go back 30 days from today,
I need to run Feb in March, ect..

Thanks

 

[tran008]

WHERE adm_ts >= DATEADD(MONTH, DATEDIFF(MONTH, 31, CURRENT_TIMESTAMP), 0),
AND adm_ts < DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0)

 

[cpagano]

THANK YOU