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 | 636 views | 6 replies

12/23/2021 3:30 pmRay BorduinWebAssist

Since it is a timestamp, it includes minutes and seconds, so the comparison for today would fail. I think you would want:

(DATE(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.