7 Replies Latest reply: May 15, 2014 10:08 AM by GuinnessDrinker _ RSS

    Help with date needed

    GuinnessDrinker _

      Hello

       

      I need help, after answering Data Krunchers plea for his project by saying that I could get all the help I needed just by reading this forum. I now realise my error in that statement

       

      I was given a report that gave a character field of  20100331 I need to finish with a date format of  31 Mar 2010

       

      I managed to get the date format of 31 March 2010 using the formula

      CtoD(Left(,4)"/"Substr(,5,2)"/"Right(,2),"y/m/d")[/CODE]

      Where the character field is called Repair Date

       

      I Have now spent quite a while searching the forum with no success

      Can somweone please help

       

      Ian