Change the date format

[Kohli]

   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

[jomar_ebonite]

Hi,

Try this

Right ( Trim ( Exp ) , 1 ) & Mid( Trim ( Exp ) , 6 , 1 )

[jomar_ebonite]

Right ( Trim ( Exp ) , 1 ) & '.' &  Mid( Trim ( Exp ) , 6 , 1 )

[raju_insights]

=Subfield(Experience,'year',1)&'.'&Subfield(Subfield(Experience,'month',1),'year',-1)

[Øystein_Kolsrud]

Here's my suggestion:

SubField(Experience,' ',1) & '.' & SubField(Experience,' ',3)

[Øystein_Kolsrud]

Ouch! I was a couple of minutes too slow