topic convert date string into proper date format in QlikView

convert date string into proper date format

Fri, 10 Oct 2014 08:27:49 GMT

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.

Re: convert date string into proper date format

maxgro — Fri, 10 Oct 2014 08:30:06 GMT

= 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

MarcoWedel — Fri, 10 Oct 2014 09:11:16 GMT

or simply

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

hope this helps

regards

Marco