topic Re: How to convert.change a date format in loading script? in QlikView

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

jim_chan — Wed, 01 Feb 2017 19:50:02 GMT

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 — Wed, 01 Feb 2017 19:50:55 GMT

Like this

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

sunny_talwar — Wed, 01 Feb 2017 19:51:57 GMT

Also, read here:

jim_chan — Wed, 01 Feb 2017 19:58:12 GMT

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

jim_chan — Wed, 01 Feb 2017 20:10:19 GMT

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

sunny_talwar — Wed, 01 Feb 2017 20:18:37 GMT

Yup