Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this
Date(Date#([MY_DATE]),'YYYYMMDD'), 'DD/M/YYYY') as [MY_DATE]
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
Yup