If statement not working

[capronton]

Can someone explain why this if statement is not working?

If DateDiff ("s", {incident_log.sched_time},{incident_log.incident_date_time} ) < -30 then "Early" else
If DateDiff ("s", {incident_log.sched_time},{incident_log.incident_date_time} ) > 330 then "Late" else
else "OnTime"

If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*SOUTH*" and {incident_log.tp_id} = 12790
then "OnTime" else
If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*NORTH*" and {incident_log.tp_id} = 12782
then "OnTime"
If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*NORTH*" and {incident_log.tp_id} = 12763
then "OnTime

 

[kray4660]

What is not working? I personally would have done the last two if's differently

If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*NORTH*" and
({incident_log.tp_id} = 12790 or {incident_log.tp_id} = 12763))
then "OnTime"


Then of course, if all the if's fail, then you will have a NULL return.

 

[capronton]

The Last 3 If statements are not executed for some reason. Can someone explain why?

 

[capronton]

For some reasons I'm not getting any "Lates" on special conditions. Please see below.
Can anyone explain why?


If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*SOUTH*" and {incident_log.tp_id} = 12790
then "OnTime" else
If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*NORTH*" and {incident_log.tp_id} = 12782
then "OnTime" else
If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*NORTH*" and {incident_log.tp_id} = 12763
then "OnTime" else
If DateDiff ("s", {incident_log.sched_time},{incident_log.incident_date_time} ) < -30 then "Early" else
If DateDiff ("s", {incident_log.sched_time},{incident_log.incident_date_time} ) > 330 then "Late" else "OnTime

 

[pmax9999]

Is it possible there simply isn't any "Lates" for the data you are returning? Are you certain you are using the correct date fields in the Datediff code?

For troubleshooting purposes, create the following formula, place it on the report and review the results.

DateDiff ("s", {incident_log.sched_time},{incident_log.incident_date_time})

Hope this helps.

Cheers
Pete

 

[capronton]

This is my first opportunity to respond. I solved the problem using the syntax below.

If {incident_log.current_route_id} = 987 and {direction_codes.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {incident_log.tp_id} = 200
then "OnTime" else
If {incident_log.current_route_id} = 987 and {direction_codes.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {incident_log.tp_id} = 58
then "OnTime" else
If {incident_log.current_route_id} = 987 and {direction_codes.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {incident_log.tp_id} = 292
then "OnTime" else
If {incident_log.current_route_id} = 103 and {direction_codes.direction_description} like "*NORTH*" and {@earlyLate} = "Early" and {incident_log.tp_id} = 12763
then "OnTime" else {@earlyLate}

Will do Pmax.

Thanks again!