Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Inserting current date, show if date is less than 364 days preceding current date, update to cur date (current date) to verify user

View all replies to this thread

Inserting current date, show if date is less than 364 days preceding current date, update to cur date (current date) to verify user

Thread began 4/07/2022 8:50 am by jo271221 | Last modified 4/07/2022 11:13 am by jo271221 | 182 views | 1 replies

4/07/2022 11:13 amRay BorduinWebAssist

For the update you can remove the hidden field and just use:

$UpdateQuery->bindColumn("verifieddate", "t", "", "WA_TIMESTAMP");

That should update with the current timestamp automatically.

Then when displaying use:
if (strtotime($WADAtbl_mytable->getColumnVal("verifieddate")) <= strtotime("-1 year") ) {

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.