How to convert.change a date format in loading script?

[jim_chan]

Hi guys,

i am facing a problem.

i have a date field with date like 20160223. now i want to change the datefiled format to 23/2/2016.

my expression is Date#(date([MY_DATE]),'DD/M/YYYY') as [MY_DATE], - but is wrong....

pls help!

Rgds,

jim

[sunny_talwar]

Like this

Date(Date#([MY_DATE]),'YYYYMMDD'), 'DD/M/YYYY') as [MY_DATE]

[sunny_talwar]

Also, read here:

Why don’t my dates work?

QlikView Date fields

Get the Dates Right

[jim_chan]

something is wrong with the scripting... error.. missing out brackets?

[jim_chan]

Date(Date#([MY_DATE],'YYYYMMDD'), 'DD/M/YYYY') as [MY_DATE] -  this only correct, too many brackets bro

[sunny_talwar]

Yup