I have been trying to get this to work based on the data bridge insert behaviour, and I have this working to post the current date and time:
.$_POST['fld_vLOCKDATE'] = date('Y-m-d H:i:s').
But, as soon as I try to amend it to add in the 8 hours extra, I end up with 0000-00-00 00:00:00 for my date and time.
This is what I have so far which isn't working:
.$_POST['fld_vLOCKDATE'] = date('Y-m-d H:i:s') + ('INTERVAL 8 HOURS').
or
.$_POST['fld_vLOCKDATE'] = date('Y-m-d H:i:s, INTERVAL 8 HOURS').
or
.$_POST['fld_vLOCKDATE'] = date('Y-m-d H:i:s' + '+8 HOURS').
and so on... many iterations of it now that I can't remember them all!
The following is what was produced as code straight from the Dat Assist extension:
.((isset($_POST["fld_vLOCKDATE"]) && $_POST["fld_vLOCKDATE"]!="" )?date("Y-m-d H:i:s", strtotime($_POST["fld_vLOCKDATE"])):"") .
And I've added the code you suggested to the hidden field in my form, but still no joy. Any thoughts on what I can do further?
Thanks so far anyway.