Inserting current date, show if date is less than 364 days preceding current date, update to cur date (current date) to verify user
*** Edited 4/7/22 11:12am CST - Part 1 ie Update is working now.
I need to be able to verify my users annually. I want to
1) Adjust my update page to insert the current date into the verifieddate column however I am using the timestamp feature already in the updated column
insert the current date when the user updates their profile however I already have the update field using the timestamp
I attempted adding this with the intent to switch to a hidden field once I have it working - This showed the correct date but did not update
<input id="verifieddate" name="verifieddate" type="text" value="<?php echo date('Y-m-d H:i:s');?>" class="formTextfield_Medium">
This displays a 1970 date and also does not update to current date
<input id="verifieddate" name="verifieddate" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("userupdate","date('Y-m-d H:i:s')"):"".$WADAtbl_mytable_update->getColumnVal("verifieddate") ."")); ?>" class="formTextfield_Medium">
2) Add a show if rule to show 'Verify Your Listing' if the users verifieddate is over 366 days from current date and also show Verified if the users verified date is less than 365 from current date
This did not work
<?php
if ($WADAtbl_mytable->getColumnVal("verifieddate") <= 'CURDATE() AND verifieddate >= DATE_ADD(now(),INTERVAL 364 DAY') {
?>
<?php echo(($WADAtbl_mytable->getColumnVal("verifieddate"))?date('D n/j/Y',strtotime($WADAtbl_mytable->getColumnVal("verifieddate"))):''); ?>
<?php
}
?>
Pages attached and links in PM