Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress records where log.scheduleTime = trip.endTime

Status
Not open for further replies.

capronton

MIS
Jun 28, 2013
159
US
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}

 
Hi,

What is a typical value of each of these fields?

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
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.
 
That's what I'm looking for!


Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
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.
 
...because, sched_time is really date and time while end_time is just time
???

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top