Text Date to Number Date?

[#1]

Is it possible to convert and date in the format, for example, 21 January 2011, into a number date format in QlikView, such as DD/MM/YYYY?

Thanks!

[nagaiank · Accepted solution]

Interpret the external date into number format using date# and then format the internal date into any desired formt using datefunction.

In your case, you may try

date(date#('21 January 2011','DD MMMM YYYY'),'DD/MM/YYYY')

[#3]

Thanks for the response. How would i make this work with any text date, rather than just 21 January 2011?

[nagaiank]

If you replace '21 January 2011' by the field name, the function will handle the value in the field.

An example is attached.

[#5]

Brilliant, works just as i require. Thanks for the help.