dtyeardiff
Syntax:
Value
Integer
dtyeardiff
(
DateTime
dt1,
DateTime
dt2)
Description:
Returns the number of years between
dt1
and
DateTime
dt2.
Examples:
($a1:$a5) = dtyeardiff("Jun 28, 2008", $b)
Before:
A
B
C
1
Sep 23, 2003
2
Aug 15, 2011
3
Dec 25, 2000
4
July 4, 1998
5
March 30, 2015
6
After:
A
B
C
1
4
Sep 23, 2003
2
-3
Aug 15, 2011
3
7
Dec 25, 2000
4
9
July 4, 1998
5
-6
March 30, 2015
6
($a1) = dtyeardiff(dtnow(), "Oct 3, 1987")