Help with dates

Question

Hi,

So here is a sample. Employee X was terminated, but then rehired.

I want it as follow

Before, I used to do this manually on excel. I used to do a pivot table and put "count" to reflect how many lines they have. and then do a VLOOKUP from the pivot table to get the count and if it was more that 1, I would check it manually.

hike44 · Answer

I think you can do it with a pretty simple flow.  I added an extra employee in there ("ZZ") to test for scenario where someone is hired and terminated twice.

dates test.yxmd

afv2688 · Answer

Hello @AHM ,

how about this?:

Regards

dates.yxmd

AkimasaKajitani · Answer

Hi @AHM

Is this workflow work well for you?

Input :

Output :

If you have any questions, please don't hesitate to contact me.

sample_wf_dates_AK.yxmd