topic Dynamically convert a date into Year,Month in App Development

Dynamically convert a date into Year,Month

souvik — Thu, 05 Mar 2020 10:02:38 GMT

Hi All,

I need to segregate the month and Year from a Column names as "Date" in which the dates are displayed like 1/12/2012,5/10/2014(MMDDYYYY) etc..

now created two more columns in the table just beside the Date: column, those are "Month" and "year"

Date Month Year

1/12/2012 --- ----

Now my question is how to put the 2012(YYYY) and 1(MM) i.e Janauary , value of the Date filed into my new "Year" and "Month" columns?

for example-----

Date Year Month

1/12/2012 2012 Jan

5/10/2014 2014 May

Can someone please help me solving this issue?

Re: Dynamically convert a date into Year,Month

tresB — Thu, 05 Mar 2020 10:21:45 GMT

That should be pretty simple using qlik functions month() and year(), like:

Month(Date) as Month

Year(Date) as Year

However, if your Date field values are not read as proper dates by qlik, you might have use date parsing function date#() additionally like:

Month(Date#(Date,'MM/DD/YYYY')) as Month

Year(Date#(Date,'MM/DD/YYYY')) as Year

Re: Dynamically convert a date into Year,Month

nikitadeshwal — Thu, 05 Mar 2020 11:58:57 GMT

First, convert your Date to DDMMYYYY format using
date(date#(Date,'MM/DD/YYYY'),'DD/MM/YYYY')as Date;
then use functions
year(Date) as Year field
month(Date) as Month field