5 Replies Latest reply on Aug 28, 2013 5:58 PM by Dan Cory

    Date Format Help String to Date

    chris.linderwell

      I am trying to turn this string into a date - 2013-07-21 21:04:20.1670000

       

      This calculated field is not working - any assistance would be appreciated

       

      DATE(

      MID([OrderDate], 6, 2)// Month

      + "/" +

      MID([OrderDate], 9, 2) // Day

      + "/" +

      LEFT([OrderDate], 4)) // Year