Report not showing correct find date from portal
My issue is as follows. I have 2 Databases that are linked by a relationship Contact Management and Work log.
Contact management shows all customer info such as name, address, phone, etc... and work log shows the history of appointments for each customer.
My issue is I'm trying to create a report that i can use for appointments. In a given day i can have 10 appointments a day. So in my portal (work log) i log the appointment into a field called ApptDate. And on the day of my appointment I would like to do a find on the ApptDate field and generate a report with all the appointments for that date.
I can generate the report with no problem but my issue is that when I look up past dates my report does not necessarily display the date that I am looking for if there is an newer date in the customers history the report displays the newer date.
So for instance I did a find on the date 11/30/2013 (see below) but i got 1 record that displays the customer info from 8/2/2014 cause its the newest date
|Patricia Bobe||Staten Island||NY||10312-5109||11/30/2013||Clean Gutters|
|Francis Demayo||Staten Island||NY||10312-5109||11/30/2013||Clean Gutters|
|Louise Meola||Staten Island||NY||10307-1601||08/02/2014||Replace Back gutters, Screen, and patch chimney|
|Dan Ramona||Staten Island||NY||10312-6228||11/30/2013||Clean Gutters|
Is there a way around this?