Convert 201501 to Jan

[#1]

How can I take a YearMonthId = 201501 and convert it to the month of Jan?

Thanks,

Joe

[jonasheisterkam · Accepted solution]

Do you mean only the Month() without Year info?=>

=month(date#(201501,'YYYYMM'))

[#3]

I separated it out to the last 2 characters using right(YearMonthId, 2) now how do I convert this 01 to January?

[#4]

Thank you. Much appreciated. Serious brainfart on that one.

Joe

[jonasheisterkam]

If you have only the number you need creation of date/timestamp if you want to use month(). You can create string and use functions like date#() oder you use makedate() with a fix year.

You can also use the defined Monthnames from the beginning of youre Skript, generatet by qlick.

=subfield(MonthNames,';',01)

[MarcoWedel]

converting 01 to January could be done like:

=Month(Date#('01','MM'))

hope this helps

regards

Marco