Calander

[#1]

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

[sunny_talwar]

Try this:

Table:

LOAD Date(A) as Date

FROM

[calander (1).xlsx]

(ooxml, no labels, table is Sheet1);

[maxgro]

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);