In a medical office I need to link two files 1) Appointments 2) Charges. I am linking on Account# and Date. The problem is that in the Appointment file, the field is a date/time (being the date and time of the appointment). In the Charges file, the field is a date/time where the time is always 12:00:00. The link, of course, is not working. My question is: Is there a way to link on only the date and ignore the time?
If you can create a sql query with all the fields you need, that would be the best thing to do.
In the Join syntax you would need to convert the datetime fields to date so that the time part is ignored.
Another way to do this is to use a Linked Subreport along with a formula in the main report that modifies the time portion to 12:00:00. Of course, this method would have performance issues.