After reading the posts on this from 2017, I’m confused on how to get the empty dates to work in a find or select command. My 65k record transaction database has some records with VisitDate and ApptTime filled in if it was an office visit and other non-visit records with both of those empty because of the way I build up the record when entering it. (those records would have neither a visit date or appt time and should be blank for clarity)
This line: find «24AvisitDate»=VisitDate AND ApptTime=(TimeSlot-1)*900+lv1
used to work in Pan 6 as it seemed to process all the empty date field records as not matching the query. In Pan X I’m not sure exactly what happens, but if a patient has a record with those empty fields before the existing matching record is found below it, it stops and doesn’t continue on to find the correct record and give info(“Found”) a value of “true”
Do I just have to empty fill all the records and record a default value in the fields going forward, or is there a way to reword the above find statement to work easily.