Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

convert date string into proper date format

Hi, I have a date variable in text format that contains values such as '02-SEP-14'. How can I convert these values into the actual date? I've tried: date(<datefield>,'DD-MMM-YY') but it does not work, it is still in text format. Thanks.

2 Replies
maxgro
Not applicable

Re: convert date string into proper date format

= date(date#('02-SEP-14', 'DD-MMM-YYYY'), 'DD/MM/YYYY')

here for detail

QlikView Date fields

MarcoWedel
Not applicable

Re: convert date string into proper date format

or simply

date#(<datefield>,'DD-MMM-YY')


hope this helps


regards


Marco