13 Replies Latest reply on Apr 30, 2018 11:00 AM by Sanford Whiteman

    Calculate number of years based on a date field

    Hossein Jalali

      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?

       

      Thanks.