Carrot reference
Functions
nextAnniversary()
given a date, returns the next upcoming anniversary of that date syntax nextanniversary(anniversarydate, fromdate) anniversarydate the date value to be evaluated by the function fromdate (optional) the date from which to find the next instance of anniversarydate return type date docid\ xtaqdzvlbtakjxrnpfwe9 sample usage nextanniversary(birthdate) returns the date one year after birthdate nextanniversary('2018 05 24', '2021 01 01') returns 2021 05 24 supported data types input type return type logic date docid\ xtaqdzvlbtakjxrnpfwe9 date docid\ xtaqdzvlbtakjxrnpfwe9 if a date value is passed, the year will be incremented by 1 if the optional fromdate parameter is passed, the year will either increment or decrement by the difference in the year values, depending on whether fromdate is before or after anniversarydate unsupported data types null docid\ n9trvqonnbknql9drnbp6 unsupported data types return null aliases birthday returns the equivalent of nextanniversary(birthdate) anniversary returns the equivalent of nextanniversary(startdate)