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....
Date(Date#([MY_DATE]),'YYYYMMDD'), 'DD/M/YYYY') as [MY_DATE]
Also, read here:
Why don’t my dates work?
QlikView Date fields
Get the Dates Right
something is wrong with the scripting... error.. missing out brackets?
Date(Date#([MY_DATE],'YYYYMMDD'), 'DD/M/YYYY') as [MY_DATE] - this only correct, too many brackets bro
Retrieving data ...