date in qlikview from string format

[bdgeddam9]

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

[anuj_sharma · Accepted solution]

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.