Month and Year from date

[amit_saini]

Hi Folks,

Could u plz see the attachment and tell me why year and month values are not visible.

Thanks,

AS

[Anonymous]

These fields Show null values in the datamodel

try year(date#(Date,'MMM DD,YYYY'))

[sunny_talwar · Accepted solution]

Try this script:

LOAD *,

  month(Date) as Month,

  year(Date) as Year;

LOAD Date#(Date, 'MMM DD, YYYY') as Date, 

     Name,

     Revision

FROM

[2015-01-31-ecoReport.xlsx]

(ooxml, embedded labels, table is RawData);

[alexandros17]

this is the correct syntax for load:

LOAD Date,
month(Date#(Date, 'MMM DD, YYYY')) as Month,
year(Date#(Date, 'MMM DD, YYYY')) as Year,
Name,
Revision
FROM
....

[buzzy996]

PFA,