Add interval in dates

• shobapond

  SSC Enthusiast

  Points: 185

  More actions

  November 1, 2007 at 12:41 am

  #183502

  Hi

  I got a small query problem:

  I have a submissionDate and i have an expiryDate field. I want to automatically calculate one year from the submissionDate and enter it into the expiryDate.

  expiryDate = CDate(Date Add(DateInterval.Day, 364, submissionDate))

  For 1-Jan-07 the expiry date will be 31-Dec-07, the problem comes on other days 25-Feb-07 gives 23-Feb-08 rather than 24-Feb-08

  Any help will be appreciated.

  Thanks

• okhere

  SSC-Addicted

  Points: 443

  More actions

  November 1, 2007 at 12:53 am

  #747324

  HI,

  Try this ..

  select DateAdd(year, 1, '29-feb-2008') expiryDate

  Osama