Convert date to years, months and days

Question & Answer
1

Hello team, I would like to know how I can create a format to show the number of years, days and months that have elapsed within a time range. It is something similar to this but with dates.

For example, if a person has 755 days, this would be the same as saying 2 years, 0 months and 25 days.

concat(
toString(dateDiff({employee_start_date},now(),"YYYY")), ' year, ',
toString(dateDiff({employee_start_date},now(),"MM")), ' month, ',
toString(dateDiff({employee_start_date},now(),"DD")),' day')
2

Try this!

concat(ifelse(floor(dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)/365)>1,concat(toString(floor(dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)/365)), ’ years, ‘),floor(dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)/365)>0,concat(toString(floor(dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)/365)), ’ year, ‘),’’),

ifelse(floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)/30)>1,concat(toString(floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)/30)), ’ months, ‘),floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)/30)>0,concat(toString(floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)/30)), ’ month, ‘),’’),’ and ',

ifelse(floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)%30)>1,concat(toString(floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)%30)), ’ days ‘),floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)%30)>0,concat(toString(floor((dateDiff({employee_start_date},now(),“DD”)dateDiff({employee_start_date},now(),“DD”)%365)%30)), ’ day ‘),’’))

This might not be exactly right because some months are 31 days instead of 30. But let me know if that helps.