2 Replies Latest reply: Oct 24, 2016 6:17 PM by Jes Lee RSS

    How do I format a data in 'JAN2015' format?

    Jes Lee

      I'm trying to format all of my dates into a single format.  I have been using one code (below) for most of the data sets, but I recently came across a data set containing dates in 'JAN2015' format.   How would I need to alter the code below?

       

       

      Date(Date#("date",'MMYYYY'),'M/D/YYYY') AS DATE,

       

      Thank you,

      Jessica