Need help converting a field into date

[Ayden]

hello need help converting a field into date.

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

[MayilVahanan · Accepted solution]

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

[Ayden]

Thanks so much for your Help. It works 

[MayilVahanan]

Happy for that.