Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Recordset for a date range – what am I doing wrong?

Recordset for a date range – what am I doing wrong?

Thread began 12/22/2021 7:35 am by Mags | Last modified 12/25/2021 11:51 am by Mags | 634 views | 6 replies

12/22/2021 9:46 amRay BorduinWebAssist

I think you want:

SELECT * FROM calendar
WHERE
(calendar.EventDate = DATE_ADD(CURDATE(),INTERVAL 1 MONTH) AND calendar.DateAdded < DATE_ADD(calendar.EventDate,INTERVAL 1 MONTH))
OR
(calendar.DateAdded = CURDATE() AND calendar.EventDate BETWEEN CURDATE() AND DATE_ADD(calendar.EventDate, INTERVAL 1 MONTH))

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.