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!