Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wajihakhan
New Contributor II

Date from YearMonth

Hi

I have a field say 'A' which has YearMonth like this (200903). From that field i want to create a date field in this format 01/03/2009

How is this possible in script? Below is sample script.

Load

     A,

     Month(date#(A,'YYYYMM')) as Month,    /* Month Name (Jan,Feb,Mar...)

     Num(Month(date#(A,'YYYYMM')),'00') as [Month Number],   /* Month Number (01,02,...,12)

     Year(date#(A,'YYYYMM')) as Year,    /* Year (2009,2010...)

Thanks

1 Solution

Accepted Solutions

Re: Date from YearMonth

May be this

Date(Date#(A, 'YYYYMM'), 'DD/MM/YYYY') as Date

3 Replies
shraddha_g
Honored Contributor III

Re: Date from YearMonth

Try

Date(MonthStart(Date#(A,'YYYYMM')),'DD/MM/YYYY') as Date,

Re: Date from YearMonth

May be this

Date(Date#(A, 'YYYYMM'), 'DD/MM/YYYY') as Date

Re: Date from YearMonth

Community Browser