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?

Outcomes