dtadd

1. Syntax:

Value DateTime  dtadd(DateTime dt1, Integer years, Integer months, Integer days, Integer hours, Integer minutes, Integer seconds)

Description:

Adds to dt1 the number of years equal to years, the number of months equal to months, the number of days equal to days, the number of hours equal to hours, the number of minutes equal to minutes and the number of seconds equal to seconds.

2. Syntax:

Value DateTime  dtadd(DateTime dt1, Integer years, Integer months, Integer days, Integer hours, Integer minutes)

Description:

Adds to dt1 the number of years equal to years, the number of months equal to months, the number of days equal to days, the number of hours equal to hours and the number of minutes equal to minutes.

3. Syntax:

Value DateTime  dtadd(DateTime dt1, Integer years, Integer months, Integer days, Integer hours)

Description:

Adds to dt1 the number of years equal to years, the number of months equal to months, the number of days equal to days and the number of hours equal to hours.

4. Syntax:

Value DateTime  dtadd(DateTime dt1, Integer years, Integer months, Integer days)

Description:

Adds to dt1 the number of years equal to years, the number of months equal to months and the number of days equal to days.

5. Syntax:

Value DateTime  dtadd(DateTime dt1, Integer years, Integer months)

Description:

Adds to dt1 the number of years equal to years and the number of months equal to months.

6. Syntax:

Value DateTime  dtadd(DateTime dt1, Integer years)

Description:

Adds to dt1 the number of years equal to years.

Examples:

($a1:$a5) = dtadd("Jun 28, 2008", $b, 0, $c)
Before:
AB C
101
2110
3250
4375
54100
6
After:
AB C
16/29/2008 12:00:00 AM01
27/8/2009 12:00:00 AM110
38/17/2010 12:00:00 AM250
49/11/2011 12:00:00 AM375
510/6/2012 12:00:00 AM4100
6
($a1) = dtadd(dtnow(), 2, 0, 31, 6, 30, 0)