Week and Month key format

[sampada0810]

I want to convert my week id and month id into a correct readable format.

May be I will do this is edit script.

my Week Id is like '20161201' and I want it as '01/02/2016'

and my Month Id is '201602' , I want this as 'Feb 2016'

Is this possible ?

Or any other way around ?

Please help!!!

[sunny_talwar · Accepted solution]

May be like this:

For Week Id

Date(Date#([Week Id], 'YYYYMMDD'), 'DD/MM/YYYY') as [Week Id],

For Month Id

Date(MonthStart(Date#([Month Id], 'YYYYMM')), 'MMM YYYY') as [Month Id],

or

MonthName(Date#([Month Id], 'YYYYMM')) as [Month Id],

[sampada0810]

Thanks for your reply.

It helped me!!