4 Replies Latest reply on Apr 30, 2018 1:25 PM by Okechukwu Ossai

    Date String in Format MMYY - Calc used but 1900s & 2000s issues

    Darren Toal

      Hello All,

       

      I want to convert a string into a date - it has the format MMYY, 0118 being January 2018, for example.

       

      I used the following calculation to convert it:

       

      DATE(LEFT([MTH Period],2)+"-"+"01"+"-"+STR(INT(RIGHT([MTH Period],2))+2000))

       

      My problem is that I have data from 1979-1999 that is now being shown as 2079 and 2099.

       

      What can I change to reflect both the 1900s data and 2000s?

       

      Many thanks!


      Darren