If the deadline is going to be one month ahead of the current date when the update is happening, then can you use this?

sorry if I underestimated your requirement

Select dateadd(mm,1, dateadd(day,0, datediff(day,0,getdate())))