[RESOLVED] Using a hidden field to enter the current date when a record is updated (PHP / SQL)
I know you can use a timestamp to do this, but I am already using that for LastUpdated, and I think SQL only lets you have one?
So I have a hidden field in my form, and have tried:
<input name="2016_Registered_Date" type="hidden" value="<?php echo date();?>" >
With no luck, so added some a date format:
<input name="2016_Registered_Date" type="hidden" value="<?php echo date('j F Y');?>" >
It seems to get the day and month, but not the year, eg 8 July 6638
Any suggestions what else to try?
Thanks.