Hi,
Looking for a solution to get the effective date for working on a location(Result(output Required)).
Employee 1
1. Got hired on 15th March so output to be 15th March for the period March.
2. Moved to US location in May and stayed there for 3 months, for July period the result to be 31st May(period since working at that location).
3. Moved back to India in August, and been working from same location thereafter, so every period return once generated should give the result as 31st Aug (period since working at that location)
4. and this may go for multiple location change
How can we formulate this to be working
Sample:
Date(Period end return) | Employee Name | Work Country | Effective Start Date | Result (output required) |
31-03-2020 | Employee 1 | India | 15-03-2020 | 15-03-2020 |
30-04-2020 | Employee 1 | India | 15-03-2020 | |
31-05-2020 | Employee 1 | US | 15-03-2020 | |
30-06-2020 | Employee 1 | US | 15-03-2020 | |
31-07-2020 | Employee 1 | US | 15-03-2020 | 31-05-2020 |
31-08-2020 | Employee 1 | India | 15-03-2020 | |
30-09-2020 | Employee 1 | India | 15-03-2020 | |
31-10-2020 | Employee 1 | India | 15-03-2020 | |
30-11-2020 | Employee 1 | India | 15-03-2020 | |
31-12-2020 | Employee 1 | India | 15-03-2020 | 31-08-2020 |
THANK YOU !!
Hi @Akhil.kohli
Time is not a dimension to the module. It's just a line item. Previous will not be working.
Thanks,
Shivankur
Try using Lookup then, creating a previous time line item in the system module for the time list