Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Populate Recordset only if current DATE and TIME matches

Populate Recordset only if current DATE and TIME matches

Thread began 10/30/2009 10:01 am by info305726 | Last modified 11/02/2009 7:32 pm by info305726 | 2324 views | 17 replies

11/02/2009 4:28 pmJason ByrnesWebAssist

OK, I think I see the problem. it is the date format:
DATE_FORMAT(NOW(), '%d-%m-%y %h:%m')

this will format the date as dd-mm-yy hh:mm

or:
02-11-09 01:11

you need to change that to:
DATE_FORMAT(NOW(), '%Y-%m-%d %h:%m')

to format the date as yyyy-mm-dd hh:mm

or:
2009-11-02 01:11

SELECT * FROM tasks WHERE tasks.dueDateTime = DATE_FORMAT(NOW(), '%Y-%m-%d %h:%m')

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.