How do I get date data to display in days months years?

Discussion created by georginger on Oct 19, 2015
Latest reply on Oct 19, 2015 by erolst

Hi Guys Working on some things that are a little out of my depth...still on a big learning curve!!


I'm trying to work out how to display an employees time in service.


I have tried Get(Current Date) - Start date which gives me a number of days as a result.  However how do display the amount of days as years, months & days?  And how can i ensure the result will be worked out on a calendar to account for changing days in months and leap years etc?


Is it even possible?


Date Fields.jpg

Would be grateful for any help on this one.