Solved: Need help converting a field into date - Qlik Community

Ayden · ‎2022-05-10

hello need help converting a field into date.

This fields has Year and month concatenated together as seen below.

MayilVahanan · ‎2022-05-10

Hi
Try like below in the script

Load *,

Date(Date#(Requirement, 'YYYY - MMM'), 'DD-MM-YYYY') as RequirementDate

from urdatasource;

Ex: Date(Date#('2022 - Aug', 'YYYY - MMM'), 'DD-MM-YYYY') <- gives 01-08-2022

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2022-05-10

Hi
Try like below in the script

Load *,

Date(Date#(Requirement, 'YYYY - MMM'), 'DD-MM-YYYY') as RequirementDate

from urdatasource;

Ex: Date(Date#('2022 - Aug', 'YYYY - MMM'), 'DD-MM-YYYY') <- gives 01-08-2022

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Ayden · ‎2022-05-10

Thanks so much for your Help. It works

MayilVahanan · ‎2022-05-11

Happy for that.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Need help converting a field into date