Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to use Make date from this format--- 'Jan-2015'
or create this in the form of date Jan-2015 like 1/1/2015 for
Feb 2015 2/1/2015
like this for whole year
Try this:
Table:
LOAD Date(A) as Date
FROM
[calander (1).xlsx]
(ooxml, no labels, table is Sheet1);
It seems you don't need any interpretation to get a date from your excel
LOAD
A,
Date(A, 'MMM-YYYY') as B
FROM
calander.xlsx
(ooxml, no labels, table is Sheet1);