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.
= date(date#('02-SEP-14', 'DD-MMM-YYYY'), 'DD/MM/YYYY')
here for detail
QlikView Date fields
hope this helps
Retrieving data ...