Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
LOAD *,
Month(Date) as Month,
Year(Date) as Year,
MonthName(Date) as MonthYear;
LOAD Date#(Date, 'DD/MM/YYYY') as Date,
....
Seems like your date might not be in DDMMYYYY format. Can you share how your datefield looks like in the raw data?
Hello sir, Let me try and send u the date field shot...
Please find the attached file.
Try this:
LOAD *,
Month(Date) as Month,
Year(Date) as Year,
MonthName(Date) as MonthYear;
LOAD Date#(Date, 'DD/MM/YYYY') as Date,
....
Hello sunny, It worked. Thanks Man