Hello everyone!
I have a problem, in Access I need to make a formula for dates for the transport plan, exactly to the columns marked in yellow (arrival_date and arrival_shift), the other columns are source data.
Is anyone able to help me?
The result in the yellow columns is the effect that I would like to achieve by creating a formula.
Thx for help
I have a problem, in Access I need to make a formula for dates for the transport plan, exactly to the columns marked in yellow (arrival_date and arrival_shift), the other columns are source data.
Is anyone able to help me?
The result in the yellow columns is the effect that I would like to achieve by creating a formula.
Thx for help
MAG_FIR_KOD | MAG_KOD | shipping day | shift | date of loading | NR | arrival_date | arrival_date | arrival_shift |
GRODZ | MZ26 | 28.01.2020 | 3 | 29.01.2020 00:00 | 1150368 | 29.01.2020 16:00 | 29.01.2020 | 2 |
GRODZ | MZ26 | 29.01.2020 | 1 | 29.01.2020 06:00 | 1150421 | 29.01.2020 11:00 | 29.01.2020 | 1 |
GRODZ | MZ26 | 29.01.2020 | 2 | 29.01.2020 14:00 | 1145082 | 29.01.2020 20:00 | 29.01.2020 | 2 |
GRODZ | MZ26 | 30.01.2020 | 1 | 30.01.2020 12:00 | 1150746 | 30.01.2020 23:00 | 30.01.2020 | 3 |
GRODZ | PD | 30.01.2020 | 1 | 30.01.2020 10:00 | 1150282 | 31.01.2020 14:00 | 31.01.2020 | 2 |
TOM | TC2 | 29.01.2020 | 3 | 30.01.2020 00:30 | 1149465 | 30.01.2020 05:00 | 29.01.2020 | 3 |