topic Re: Month year number to month in App Development

Month year number to month

krish2459 — Sat, 16 Nov 2024 20:24:43 GMT

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 — Mon, 22 Jul 2019 13:01:15 GMT

Try Date(MonthYear,'MMM') as Month

tresB — Mon, 22 Jul 2019 13:05:57 GMT

You need month; use month().

Month(MonthYear)

krish2459 — Mon, 22 Jul 2019 13:15:11 GMT

Hi ,

Not able to get the format.

Please find the sample sheet.I'm using qliksense

Thanks..

Frank_Hartmann — Mon, 22 Jul 2019 13:21:19 GMT

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

krish2459 — Mon, 22 Jul 2019 13:31:31 GMT

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 — Mon, 22 Jul 2019 13:41:51 GMT

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 — Wed, 24 Jul 2019 06:16:25 GMT

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