Location Transfers during the current year
Summary
How to get the location for the first of the year and any changes throughout the yearContent
Hi All,
I have a requirement to pull in changes to an Employees Work Location for Tax purposes at the end of the year.
I was trying to build a report that pulls in where an employee was located for Jan 1, 2020 but I keep getting duplicated rows (only want what they were on the first of the year), then I need to determine if the location changed throughout the year and report the change
I have a previous and current report but that takes the current (today record) and looks for the previous - I want to start the other way if possible