title: How to get Next month date from today date (i.e) exactly one month expires from today date
body: <p>I have maintained two datas into my table</p>
  
  <p>1 column     2 column
  PaidDate    validitydate</p>
  
  <p>in padidate ill give insert todaydate. but in validity date i may either insert validity for 1 week/1 month.</p>
  
  <p>I have used validity=DATEADD(Day,7,@paiddate) to insert validity for 1 week. but how to gtet the validity for 1 month from todays date</p>