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?