Dateformat in dimension

[qvhjenvo]

Hi,

I have a statusdate as dimension. Values for the statusdate for ex.

statusdate

20130228

20130430

20130531

What I want is, for ex.

statusdate      formatedStatusdate

20130228      28.02.2013

20130430     30.04.2013

20130531     31.05.2013

Some hints?

[maxgro]

date(date#('20130228', 'YYYYMMDD'), 'DD.MM.YYYY')

replace 20130228 with statusdate

date(date#(statusdate, 'YYYYMMDD'), 'DD.MM.YYYY')

[MK_QSL]

Use below in your script for statusdate

Date(Date#(statusdate,'YYYYMMDD'),'DD.MM.YYYY') as statusdate