Date format changes

[sonysree88]

Hi Everyone,

Could you please resolve this issue..

in my dashboard i have the date feild data like this Tue-06-2016 01.52.10 AM

am unable to extract from this date to years or months any another extraction

It would be appreciate if it solved ASAP

written expression as : Year(Date field)

Month(Date Field)

Thanks

Sonysree

[#2]

Try This

//Tue-06-2016 01.52.10 AM, Date and year

Tab1:

LOAD

Date,

Timestamp#(Left(Trim(mid(Date,5)),7),'MM-YYYY')as Date1

FROM

[\Date Field.xlsx]

(ooxml, embedded labels, table is Sheet1);

Load

Year(Date1)as DateYear,

Month(Date1) as MonthYear

Resident Tab1;