Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
You need month; use month().
Month(MonthYear)
LOAD @1,Month(@1) as Month
FROM
[C:\Users\admin\Downloads\Book5.xlsx]
(ooxml, no labels, table is Sheet1, filters(
Transpose()
));
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..
LOAD @1,date(date(@1),'MMM-YY') as date
FROM
[C:\Users\admin\Downloads\Book5.xlsx]
(ooxml, no labels, table is Sheet1, filters(
Transpose()
));
LOAD @1,date(@1,'MMM-YY') as monyr
FROM
Book5.xlsx
(ooxml, no labels, table is Sheet1, filters(
Transpose()
));