Newbie needs help!

[ad23]

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

[AngelosPachis · Accepted solution]

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

[ad23]

Thanks a lot!

[atcodedog05 · Accepted solution]

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 : )

[ad23]

Absolutely. Thanks much!

[atcodedog05]

Happy to help : ) @ad23 

Cheers and have a nice day!