Date Generation

[akpofureenughwu]

Good day sir, I'm working on a excel file and I tried a code to generate day,month, year field from the existing date field but my output is blank or empty. I will need help from the community for this and possible help generate the quarter field too. Find attached files for clarity.

[sunny_talwar]

Seems like your date might not be in DDMMYYYY format. Can you share how your datefield looks like in the raw data?

[akpofureenughwu]

Hello sir, Let me try and send u the date field shot...

Please find the attached file.

[sunny_talwar · Accepted solution]

Try this:

LOAD *,

          Month(Date) as Month,

          Year(Date) as Year,

          MonthName(Date) as MonthYear;

LOAD Date#(Date, 'DD/MM/YYYY') as Date,

          ....

[akpofureenughwu]

Hello sunny, It worked. Thanks Man