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:
After:
6/29/2008 12:00:00 AM | 0 | 1 |
7/8/2009 12:00:00 AM | 1 | 10 |
8/17/2010 12:00:00 AM | 2 | 50 |
9/11/2011 12:00:00 AM | 3 | 75 |
10/6/2012 12:00:00 AM | 4 | 100 |
|
($a1) = dtadd(dtnow(), 2, 0, 31, 6, 30, 0)