Month year number to month

[krish2459]

Hi,

We have month year values as 43800,43525..

We nee to get month name from that.

Please let me know how to get month.

Thanks...

[Uday_Pasupuleti]

Try Date(MonthYear,'MMM') as Month

[tresesco]

You need month; use month().

Month(MonthYear)

[krish2459]

Spoiler

Hi ,



Not able to get the format.



Please find the sample sheet.I'm using qliksense



Thanks..

[Frank_Hartmann]

LOAD @1,Month(@1) as Month
FROM
[C:\Users\admin\Downloads\Book5.xlsx]
(ooxml, no labels, table is Sheet1, filters(
Transpose()
));

[krish2459]

Hi,

We need to covert the month year number from the excel to MMM-YY.

But I'm getting month year numbers as 40800....

Thanks..

[Frank_Hartmann]

LOAD @1,date(date(@1),'MMM-YY') as date
FROM
[C:\Users\admin\Downloads\Book5.xlsx]
(ooxml, no labels, table is Sheet1, filters(
Transpose()
));

[fallenangel6]

LOAD @1,date(@1,'MMM-YY') as monyr
FROM
Book5.xlsx
(ooxml, no labels, table is Sheet1, filters(
Transpose()
));