Open Dental Forum

osjaved wrote: Sat Apr 25, 2026 6:25 pm I am using PUT ShortQuery: https://api.opendental.com/api/v1/queries/ShortQuery

The following query does not return any results beyond 2020-09-26:
"SqlCommand": "SET @FromDate= '2020-04-29', @ToDate='2026-04-31'; select a.AptDateTime, p.FName, p.WirelessPhone FROM appointment a INNER JOIN patient p ON p.PatNum=a.PatNum WHERE a.AptDateTime BETWEEN @FromDate AND @ToDate"

I need it to return data in future i.e. pull patients with upcoming appointments (and not in the past)

So this does not return any results although there are appointments on 4/29/2026
"SqlCommand": "SET @FromDate= '2026-04-29', @ToDate='2026-04-31'; select a.AptDateTime, p.FName, p.WirelessPhone FROM appointment a INNER JOIN patient p ON p.PatNum=a.PatNum WHERE a.AptDateTime BETWEEN @FromDate AND @ToDate"

Can someone help with that please?

Thanks

SELECT
  a.AptDateTime,
  p.FName,
  p.WirelessPhone
FROM appointment a
INNER JOIN patient p
  ON p.PatNum = a.PatNum
WHERE a.AptDateTime >= '2026-04-29 00:00:00'
  AND a.AptDateTime <  '2026-04-30 00:00:00'
ORDER BY a.AptDateTime;

Tom Zaccaria wrote: Mon Apr 27, 2026 6:35 am Take 2:

select a.AptDateTime, p.FName, p.WirelessPhone
FROM appointment a
INNER JOIN patient p ON p.PatNum=a.PatNum WHERE
(DATE(a.AptDateTime)
BETWEEN Curdate()+Interval 2 Day AND Curdate()+Interval 2 Day) AND a.AptStatus IN (1,2,4)

You will have to manipulate the interval days.

drtmz

osjaved wrote: Mon Apr 27, 2026 3:16 pm Tried this one and still getting the same result
OD2.jpg

SELECT AptDateTime from appointment WHERE AptNum=279;