Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm having trouble converting the date format eg. 201202, into Monthyear ie. Feb-2012
I've tried a number of different expressions, but seem to be going around in circles.
Any ideas?
Many thanks
date(date#('201202','YYYYMM'),'MMM-YYYY')
date(date#('201202','YYYYMM'),'MMM-YYYY')
Hello Beanz,
You can try this:
Test:
LOAD * INLINE [
Dates
201202
201201
201204
];
LOAD replace(MonthName(MakeDate(left(Dates,4),right(Dates,2))),' ','-') as DateNew Resident Test;
Let me know if it was helpful, or anything else is required.
thanks,
itsangad
@Gysbert surely has given a better solution.