convert date string into proper date format

[#1]

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.

[maxgro]

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

here for detail

QlikView Date fields

[MarcoWedel]

or simply

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

hope this helps

regards

Marco