Converting into Date format

[dunkindonut7777]

Hi I have a data here that I want to add a resigned date. I need to know what/when is the resigned date using the tenure and date hired column. 

Staff #	DATE HIRED	TENURE	Years	Months	Days	Resigned Date
777990	6/11/2021	3Years, 1Months, 25Days	3Years	1Months	25Days
983493	2/25/2013	11Years, 5Months, 11Days	11Years	5Months	11Days
438535	1/21/2020	4Years, 6Months, 15Days	4Years	6Months	15Days
493859	7/21/2023	1Years, 0Months, 15Days	1Years	0Months	15Days
947395	5/7/2024	0Years, 2Months, 29Days	0Years	2Months	29Days

Can you help me with this one?

[cjaneczko · Accepted solution]

Here is one way to do it. You will need to clean the text out of the Years/Months/Days first.

datetimeadd(datetimeadd(datetimeadd(DateTimeParse([DATE HIRED ],'%m/%d/%Y'),tonumber([Years]),'years'),ToNumber([Months]),'months'),ToNumber([Days]),'days')

[ChrisTX · Accepted solution]

Try the attached workflow.  Also become familiar with all of the DateTime Functions (alteryx.com)

 

Chris