5 Replies Latest reply: Oct 16, 2018 1:53 AM by Øystein Kolsrud RSS

    Change the date format

    xxxxx yyyyy

         I have one field name with Experience. How can covert into  year month format, like 2.1

                

                      Experience

                2 year 1 months 10 days

                1 year 7 months 15 days

                2 year 1 months 10 days

                2 year 1 months 10 days

               4 year 1 months 10 days

               1 year 1 months 10 days

               4 year 1 months 10 days

               2 year 1 months 10 days

               5 year 1 months 10 days

               3 year 1 months 10 days

               3 year 1 months 10 days

               4 year 1 months 10 days

               3 year 1 months 10 days  ;


      O/P like:

                 Exp

                 2.1

                 1.7

                  2.1

                  2.1

                  4.1

                  1.1

                  4.1