Suppress records where log.scheduleTime = trip.endTime

[capronton]

I would like to suppress records in two different tables.

I put the code below in "detail section expert" and it is not working. Can someone assist?

{incident_log.sched_time} = {trip.end_time}

 

[SkipVought]

Hi,

What is a typical value of each of these fields?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[kray4660]

Just wondering, if one or both of those fields are datetime and they do not match exactly (i.e., 1/1/2017 08:00:00, 1/1/2017 08:00:01) then you run into an issue. I recently had a similar issue and needed to convert both of my datetimes to dates.

 

[SkipVought]

That's what I'm looking for!


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[capronton]

Thanks all for you feedback. I apologize for not responding sooner.

I was able to solve the problem by putting the code below in the "Section Expert" suppress formula.

Time({incident_log.sched_time}) = Time({trip.end_time})

Thanks again.

 

[SkipVought]

...because, sched_time is really date and time while end_time is just time
???

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]