Hi All;
Please see attached my data source.
I calculated my loading duration as follows:
Interval( [First Pick Departure Date]-[First Pick Arrival Date],'mm') as LoadingDuration
I now want my model to say if [First Pick Arrival Date] has a time greater than or equal to 17H00 but less than 23H59 then let [First Pick Arrival Date] be the following day at 08H00. If [First Pick Arrival Date] has a time between 00H00 and less than 08H00 then change time on [First Pick Arrival Date] field to be 08H00 but the date will remain the same.
In other words if a truck arrives when the loading site is closed, l want my model to use 08H00 when the loading site is open to calculate the LoadingDuration field.
Please assist.
Regards;
Moses
