How to get the date of the next month from today (i.e. exactly one month will expire from today

Question

I saved two tables in a table

1 column 2 columns PaidDate validitydate

in padidate is bad to give todaydate paste. but on the validity date I can either insert a validity period of 1 week / 1 month.

I used validity = DATEADD (Day 7, @paiddate) to insert a validity period of 1 week. but as gtet valid for 1 month from today

Answer 1

Isn't it like that:

validity = DATEADD(month, 1, @paiddate)

Answer 2

DATE_ADD supports units.