Creating a field with multiple conditions

[dunkindonut7777]

Hello I want to ask for your help regarding the data I have. I want to create the "Date" field using the conditions stated in the table below:

Month	Period	ID code	Year	Date
February	1st Period		2023	2/10/2023
July	2nd Period		2022	7/25/2022
December	Special payroll		2022	12/25/2022
December	Annualization		2022	12/25/2022
May	Month Pay		2023	5/25/2023
November	Month Pay		2022	11/25/2022
April	Final Pay	2007NA	2023	04/27/2023
August	Final Pay	1911AB	2022	1/9/2022
December	Final Pay	2107CB	2022	11/17/2022

How can I set the "Date" field using the month, period, id code and year values, considering that some ID codes are empty. Can you help me with this one please?

[FinnCharlton]

Hi @dunkindonut7777 , what is the logic that decides which day within the month these events fall on? i.e. How do we know that April final pay is on the 27th? If there is no additional logic and those are just the days these events fall on, I would make a lookup table with all events and relevant days. You can then join the lookup table to any data you need to add the dates to in the future