Date Comparisons
Comments
-
Version 3.5.1
We have a list of employer objects with employment hire and termination dates. We are looking for a way to identify gaps in the employment dates? Is this something we could do in a truth table or a subflow? Can you recommend something that could handle this?
Thank you,
-
Hi,
Im sorry I do not understand your question. Are you looking to get the amount of days they were hired based off the Employment hire Date and the Termination Date?
-
This is a hard one to explain. So, given hire and termination dates for a set of employers…is there more than a 30 day gap between any termination date of one employer and hire date of a different employer.
-
So what you can do is create a subflow. In this subflow you will fetch the Termination Dates and Hire Dates of the employees and sort them on the Fetch step to be from oldest to newest. Then use a foreach step for the collection of the entities, and on the
ext" path use a "Get Time Span Between" and set the base dates on that after each loop