topic date in qlikview from string format in App Development

date in qlikview from string format

bdgeddam9 — Wed, 11 Jul 2018 12:22:21 GMT

Hi All,

I have the following script:

t1:

load * inline [

date1

feb 2018,

jan 2018,

march 2018

];

obviously as you can see it is in string format but i need in date and as 01/01/2018 i.e. dd/mm/yyyy format. How to do this

Re: date in qlikview from string format

anuj_sharma — Wed, 11 Jul 2018 12:44:24 GMT

t1:

load * ,date(date#(date1,'MMM YY'),'MMMYY') as Date inline [

date1

feb 2018,

jan 2018,

march 2018

];

In general, Date(Date#(StringField,'ApparentFormat'),'RequiredFormat') works.