I'm trying to set up a report in Crystal that shows target times for deliveries.
Our contractor has the following rules:
If the job is logged Monday - Friday the target delivery is 24 hours
If the job is logged Saturday all day or Sunday before 12pm the target is 12pm on the next Monday.
If the job is logged after 12pm on Sunday the target is 24 hours.
I've created a long-winded way of sort of doing it by creating a
ToText formula for the day and one for the time
And then saying
if @day = "saturday" and @time = "13" then
PPV.DATERECEIVED+47
and changing the time and date received values but this doesn't give me an exact 5pm period.
Surely there is a quicker way that can check the date and time a job was logged and produce a set time if the condition is met?