Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Highlighted
MVP
MVP

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

Re: convert date string into proper date format

or simply

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


hope this helps


regards


Marco