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:
AB C
1Sep 23, 2003
2Aug 15, 2011
3Dec 25, 2000
4July 4, 1998
5March 30, 2015
6
After:
AB C
14Sep 23, 2003
2-3Aug 15, 2011
37Dec 25, 2000
49July 4, 1998
5-6March 30, 2015
6
($a1) = dtyeardiff(dtnow(), "Oct 3, 1987")