topic Re: How do I format a data in 'JAN2015' format? in App Development

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

jleefjcapital — Tue, 04 Oct 2016 23:05:28 GMT

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

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

sunny_talwar — Tue, 04 Oct 2016 23:07:20 GMT

May be this:

Date(Date#("date",'MMMYYYY'),'M/D/YYYY') as DATE,

Date(Date#(Capitalize("date"),'MMMYYYY'),'M/D/YYYY') as DATE,

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

jleefjcapital — Mon, 24 Oct 2016 22:17:28 GMT

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!