1 2 Previous Next 27 Replies Latest reply on Nov 15, 2016 1:24 AM by Simon Runc

    How can I split number of months to year and months.


      Hi ,


      I have a scenario in which ,i have to calculate the time  a particular customer was with our company.I calculated the months he was with our company using datediff('month',dt cust added,today()).SO i got result as say for example 135 months.But I want to display as 11 years and 3 months.How can we do that?Simon Runc.Or is there any other easy way other than datediff to achieve the required result?

        1 2 Previous Next