3 Replies Latest reply on Dec 6, 2017 6:46 PM by Manish Mehra

    Date client turns a specific age from a given DOB

    Dacre Staines

      we contact our clients when they hit a specific age 21, 30, 40, 50, 60, 70, 80, 90. Firstly i need to know how to calculate a clients age today? Secondly how could I create a formula to work out which of the clients are going to reach one of these specific ages in 2018 and display the date they are going to reach it? For example with a dob of the 20/01/1978 the client is 39 and will be 40 on the 20/01/2018. i want to create a visualisation to show the ca lender year and which clients turn 21, 30, 40, 50, 60, 70, 80, 90 on given days. this is way beyond me but hopefully someone can help?!