AnsweredAssumed Answered

I would like to get the age of the created date as a number

Question asked by cmilton1 on Feb 5, 2019
Latest reply on Feb 5, 2019 by Mike Duncan

I would like to add a calculation to my customer records that will display how long they have been a customer.


I know FileMaker uses numbers to generate dates but not sure on the convention exactly.


I have the auto enter created date for each record so could I use a variation of this calculation to achieve my result?


(Get (Current Date) - (Customer : CreatedOnDate)) to get the number of days? Then just divide ( / ) by 3?


I tried that strategy and the result is a long series of numbers.


What am I doing wrong?