AddDays                                                                                                  Function

 

ADDDAYS(theDate as Date, Days as Integer)

 

Description

Adds days to theDate and returns the new date value.

 

theDate should be a valid date value.

 

Example

Dim theDate as Date

Dim newDate as Date

TheDate=ToDate("03/01/98")

newDate=AddDays(theDate, 45) 'adds 45 days

 

newDate will now have a date of April 14, 1998