AnsweredAssumed Answered

Format a calculated field

Question asked by Brian Curran on Mar 20, 2018
Latest reply on Mar 23, 2018 by Brian Curran

Hi,

I have used the following formula to calculate the number of days from when a contract started until today:

abs(subtract(daysUntil(today()),daysUntil($date_started_c)))

 

The above returns 413 days based on a contract start date of 01st Feb 2017. I would like to format so that it reads as follows:

1 year, 1 month and 20 days

 

Ideally, I would like to show the year, month and day in singular and plural depending on the number. For example:

05th Aug 2002 =

15 years, 7 months and 16 days.

 

Any suggestions on where/how to do this would be great.

Brian.

Outcomes