Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Date Generation

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.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

LOAD *,

          Month(Date) as Month,

          Year(Date) as Year,

          MonthName(Date) as MonthYear;

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

          ....

View solution in original post

4 Replies
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
Creator III
Creator III
Author

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

Please find the attached file.

sunny_talwar

Try this:

LOAD *,

          Month(Date) as Month,

          Year(Date) as Year,

          MonthName(Date) as MonthYear;

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

          ....

akpofureenughwu
Creator III
Creator III
Author

Hello sunny, It worked. Thanks Man