3 Replies Latest reply on Nov 13, 2012 8:18 AM by Shawn Wallwork

    Dates formatting - eliminating extra characteres to read as date

    C Palo

      Hello all,

       

      I am working with IRI data and the dates come as

      1 Week Ending Oct 8, 2010,

      1 Week Ending Oct 17, 2010,

      1 Week Ending Oct 24, 2010 and so forth

       

      I tried using a DATE(RIGHT([TIME IRI],12)) however when the date is single digit, it should read DATE(RIGHT([TIME IRI],11))...How can I eliminate the "1 Week Ending" and be left with everything else?

       

      Thanks,

       

      Cristina