Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Date(Date#("date",'MMMYYYY'),'M/D/YYYY') as DATE,
or
Date(Date#(Capitalize("date"),'MMMYYYY'),'M/D/YYYY') as DATE,
On a related note, I am also trying to combine two date series (Year column and Month Column) into a single Date column. Would you be able to help me with this?
Thanks!