Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jleefjcapital
Contributor II

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

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

2 Replies

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

May be this:

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

or


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

jleefjcapital
Contributor II

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

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!