1 Reply Latest reply on Aug 8, 2013 6:15 PM by Jonathan Drummey

    Date and Time Calculated Field(s): 1 or more fields???

    Daniel Eldridge

      I have a csv file that contains a DATE and a TIME field.

       

      The DATE field is in this format: MMDDYYYY where MM ranges from 01 to 12; DD ranges from 01 to 31 and YYYY ranges from 2000 to 2012

       

      While the TIME field looks like this: HH:MM

       

      NB: all values are padded with leading zeros.

       

      Is there any advantage to creating more than one TimeStamp field?

       

      Exactly how do I create this--presumably--calculated field?

       

      I know how to extract/create the date, but I'm lost when it comes to TIME:

       

      DATE(

      LEFT([Order Date], 2) // This covers the DD segment

      + "-" +

      MID([Order Date], 3, 3) // The MMM segment

      + "-" +

      RIGHT([Order Date], 2) // The last two digits of YYYY

      )