Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a created variable; see below;
24250 seems a October.
but any one knows what is the date format for that?
my two questions regarding this
1. How I can convert this series number to date format
2. May I deploy a formula rather than inputting a hard code there?
Thanks
you can try this way
=date(date#(DateField,'yyyymmdd'),'yyyymmdd')
and have a look here
https://community.qlik.com/t5/New-to-QlikView/convert-integer-column-into-date/m-p/1252234
you can try this way
=date(date#(DateField,'yyyymmdd'),'yyyymmdd')
and have a look here
https://community.qlik.com/t5/New-to-QlikView/convert-integer-column-into-date/m-p/1252234
Thanks. It turns out that 24250 is after a process of calculation.
your formula is helpful. thanks