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 10/28/2021 8:23 am by Ray Borduin | 98 views | 3 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...

10/28/2021 7:23 am | #3 jo271221

This is working but the server time must be off as it switches to the next before 7pm. Is anyone familiar with the server time settings using Amazon AWS for hosting. I am guessing this is in the EC2 settings.

10/28/2021 8:23 am | #4 Ray BorduinWebAssist

I googled: "update server time for AWS server" and found some rather complex steps to do it, but it should be possible.

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.