6 Replies Latest reply on Oct 19, 2015 10:11 AM by erolst

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


      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.