Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scenario like below,
Test=201216
I have to convert this value into month by below case,
201216 as DEC 16, last two digits are number(16), and 3rd and 4th digits represents as month(ex: 12 as DEC,1 as JAN,2 as FEB,etc..)
Thanks,
Mahi
May be like this:
Month(Date('201216', 'DDMMYY'))
My bad, try this:
=Month(Date#('201216', 'DDMMYY'))
Sunny,
I have to use column name 'Test' to convert the set of values, for example
if 201216 -->DEC 16
200810-->AUG 10
Thanks,
Mahesh
Try this:
=Date(Date#(Test, 'DDMMYY'), 'MMM YY') as Test
maybe
=Date(MonthStart(Date#(Test, 'DDMMYY')), 'MMM YY') as Test
to avoid multiple values with the same text representation but different numerical values.
regards
Marco