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

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

    Jessica 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,