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




          populating a calculated field of CHARACTER type.


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




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