Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › show records current date plus 10 days

show records current date plus 10 days

Thread began 4/24/2021 2:06 pm by jo271221 | Last modified 4/24/2021 3:45 pm by Ray Borduin | 23 views | 1 replies |

4/24/2021 2:06 pm | #1 jo271221

show records current date plus 10 days

I currently use this and update the code weekly to show the upcoming eventseventdate <= '2021-04-26' AND enddate >= CURDATE()

I would like to show events that occur today and then next days, something like
curdate ()'+ 10' AND enddate >= CURDATE()
to reflect the current date plus the next 10 days.

Thank you!

4/24/2021 3:45 pm | #2 Ray BorduinWebAssist

AND enddate >= CURDATE() AND enddate <= DATE_ADD(now(),INTERVAL 10 DAY)

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.