CONVERTING DIGIT TO DATE FORMAT

[dunkindonut7777]

Hi I would just like to ask if how can I convert these values into date? I think it came from the software they generated. Can you explain how is this possible to convert as a date? I want it to convert as (yyyy-MM-dd) format.

Date	Period
44013	July2020
44015	July2020
44041	July2020

Expected Output:

Date	Expected Date
44013	2020-07-01
44015	2020-07-01
44041	2020-07-29

Would like to assist me with this one pls thanks.

[atcodedog05]

Hi @dunkindonut7777 

Here is how you can do it.

Workflow:

Hope this helps : )