Date format

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

date(date#('201202','YYYYMM'),'MMM-YYYY')

[#3]

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

[#4]

@Gysbert surely has given a better solution.