I need SQL Query in marketing cloud to get the second day of next month. For eg, if my current date is 8/4/2021 then my bill should be generated on 2/5/2021. Please guide me on this.

I also need to SQL query to get a particular day in next month.


Something like this?

Today + ((last day of month - current day of month) + 2)

Dateadd(dd, (DAY(EOMONTH(GETDATE()))-DATEPART(day, getdate()))+2, getdate()) AS TargetDate 
from ###

Not the answer you're looking for? Browse other questions tagged or ask your own question.