Discussion board where members can get started with Qlik Sense.
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.
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...)
Go to Solution.
May be this
Date(Date#(A, 'YYYYMM'), 'DD/MM/YYYY') as Date
Date(MonthStart(Date#(A,'YYYYMM')),'DD/MM/YYYY') as Date,
Also, look here:
QlikView Date fields
Why don’t my dates work?
Get the Dates Right