Swap Shift Times to One day to other Day

[dkma]

EID	NewShiftDate	ShiftID	OriginalSHiftDate	From	To
111111	07-11-2021	s1	12-11-2021	12-11-2021 23:00	13-11-2021 03:00
111111	07-11-2021	s1	12-11-2021	13-11-2021 03:00	13-11-2021 03:30
111111	07-11-2021	s1	12-11-2021	13-11-2021 03:30	13-11-2021 06:30
222222	08-11-2021	s2	10-01-1900	10-11-2021 01:00	10-11-2021 05:00
222222	08-11-2021	s2	10-01-1900	10-11-2021 05:00	10-11-2021 05:30
222222	08-11-2021	s2	10-01-1900	10-11-2021 05:30	10-11-2021 08:30

Hi All,

I have the above Data Set, I would need to swap the all the shift timings to originalShiftDate to new SHift Date with out changing the Duration of From-To..

Can any one have any workaround to achieve this 🙂

[binuacs]

@dkma  can you please post the expected result as well?

[afv2688]

Hello @dkma ,

I don't know if I got right what you are looking for. Is it something like this?

Regards

[dkma]

@binuacs 

EID	NewShiftDate	ShiftID	OriginalSHiftDate	New From	New To
111111	07-11-2021	s1	12-11-2021	07-11-2021 23:00	08-11-2021 03:00
111111	07-11-2021	s1	12-11-2021	08-11-2021 03:00	08-11-2021 03:30
111111	07-11-2021	s1	12-11-2021	08-11-2021 03:30	08-11-2021 06:30
222222	08-11-2021	s2	10-01-1900	08-11-2021 01:00	08-11-2021 05:00
222222	08-11-2021	s2	10-01-1900	08-11-2021 05:00	08-11-2021 05:30
222222	08-11-2021	s2	10-01-1900	08-11-2021 05:30	08-11-2021 08:30

[dkma]

@binuacs @afv2688 

Temp Column should be increased based on the From Column

[dkma]

temp_column
12-11-2021
13-11-2021
13-11-2021
10-01-1900
10-01-1900
10-01-1900

Temp column should be like this

[afv2688]

Hello @dkma ,

this should do it 🙂

Regards