|
My Table has the following fields:
ID “Auto number”
firstname “text”
lastname “text”
ptnumber “text” unique number
nextapt “date/time”
Nextapt field contains dates that could be old or new dates for the same person. I want to find a way using DRW, who does not have an appointment! Meaning not today or in the future! Any ideas please?
fp_sQry="SELECT DISTINCT firstname,lastname, ptnumber, enrolled FROM appt WHERE enrolled = 'AC' AND nextapt NOT BETWEEN #::todaydate::# And #::todaydate::#+3650 ORDER BY lastname ASC"
For some reasons it returns people with future appointments as well! New appointments wont go more than max 2 months! Is the syntax correct?
| 
