Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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],
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],
Thanks for your reply.
It helped me!!