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?
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