Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
bdgeddam9
New Contributor

date in qlikview from string format

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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: date in qlikview from string format

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.

1 Reply
Partner
Partner

Re: date in qlikview from string format

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.