1 Reply Latest reply: May 15, 2014 10:02 AM by Grant Perkins RSS

    Date Formatting

    JCC _

      I need to convert 08/24/2008 to just 08/24/08. What is the easiest method to do that. The source is a text file. Thanks for you help. V7.0Pro.[/FONT]

       

      For GMT Stop Date: 08/24/2008

        • Date Formatting
          Grant Perkins

          If the source is a text file and you are reading the nominal date string into a field as text the simplest formula would be

           

          left(textfield,6)+right(textfield,2)

           

          populating a calculated field of CHARACTER type.

           

          If the string is importing as a date than you would need something like

           

          left(DtoC(textfield),6)+right(DtoC(textfield),2)

           

          By default Monarch will always output a YYYY year so a YY year must be presented as a character field not a date field.

           

           

          HTH.

           

           

           

          Grant