AnsweredAssumed Answered

Calculate number of years based on a date field

Question asked by 1eb30b6118cc520d63333b263e84ac9454eef29b on Mar 19, 2018
Latest reply on Mar 27, 2019 by Test Person

We are looking to create an automation in which the client has a date field called Client Anniversary that basically shows the joining date.

The automation sends out an email on the anniversary which is fine (we have built) but inside the email there is a part where it says:


Can you believe it has been X year(s) since you joined our family?


That X field needs to basically come from calculating This year - Client Anniversary year and give us a number (ie. 1, 2, or 3 ...)


Has anyone ever worked with something like this and know how it can be achieved?