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?

    georginger

      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.