Hi All,
I have the below table and for each employee I want to add a row for every month he has worked (from the hire date). For attired employee this should stop the month before the employee is attired. I have done the first piece of workflow (attached) but struggling to add the if condition in the loop for attired employees - not sure where and how. Any help will be highly appreciated. Thanks!
Emp ID | Emp Name | Hire Date | Attr Date |
1 | AB | 12/10/2018 | |
2 | CD | 1/1/2019 | 1/1/2020 |
3 | EF | 5/10/2021 | |
4 | GH | 3/17/2019 | 2/2/2022 |
5 | IJ | 9/12/2020 |
¡Resuelto! Ir a solución.
Hi @ad23 ,
You were close, you should first convert your date fields to a date format and then come up with an if statement subject to whether the attr date field is populated or not
Hope that helps,
Angelos
Thanks a lot!
Hi @ad23
My take on this. Generate an endate column like this and generate rows till the end in the same way
Hope this helps : )
Absolutely. Thanks much!
Happy to help : ) @ad23
Cheers and have a nice day!