website logo
Navigate through spaces
ChartHop documentation
⌘K
ChartHop Help Center
Getting around in ChartHop
ChartHop for Employees
Implementing ChartHop
ChartHop for Administrators
Carrot reference
ChartHop for Developers
Partners
Release notes
Resources
Docs powered by
Archbee
website logo
Carrot reference
...
Elements of Carrot expressions
Functions

diffYears()

Returns the total number of years between two given dates.

Syntax

diffYears(date1, date2)

  • date1 - the date from which counting begins.
  • date2 - the date at which counting ceases.
  • Return type: Number

Sample usage

diffYears('2021-10-11', '2020-10-11') returns 1.

Supported data types

Input type

Return type

Logic

Date (x2)

Number

The function will count the number of years beginning with date1, and ending with date2.

Unsupported data types

Null

Unsupported data types return Null.



Updated 03 May 2023
Did this page help you?
PREVIOUS
daysOffBetween()
NEXT
diffMonths()
Docs powered by
Archbee
TABLE OF CONTENTS
Syntax
Sample usage
Supported data types
Docs powered by
Archbee