Insert Current date and expiry date

Can someone help me. I am trying to set up a registration form for an annual subscription.

There will be two hidden fields:
1) The current date of registration
2) The expiry date, which is exactly 1 year later
Can this be done? As a novice, any assitance would be much appreciated

use the following code for the current date:

<?php echo(date("Y-m-d h:m:s")); ?>

and this code for one year from now:

<?php echo(date("Y-m-d h:m:s", mktime(date("h"), date("m"), date("s"), date("m"), date("d"), date("Y") + 1))); ?>

BRILLIANT - many thanks Jason

A shorter way to do the date a year from now is:

<?php echo(date("Y-m-d h:n:s", strtotime("+1 year"))); ?>

Many thanks but I still can't get it to work so perhaps I gave you the wrong information.

I have set the mysql database fields to DATE

The current form code for I want to change for subscribe date and 1 year later unsubscribe date is:

<input id="HiddenFields_userSubscribeDate" name="HiddenFields_userSubscribeDate" type="hidden" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","HiddenFields_userSubscribeDate"):"")); ?>">

<input id="HiddenFields_userExpiryDate" name="HiddenFields_userExpiryDate" type="hidden" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","HiddenFields_userExpiryDate"):"")); ?>">

I have tried pasting in the code you provided in to the value = "" but it won't add to the database. Can you advise where I am going wrong. A million thanks

if the code for generating the date is added correctly to the value of the hidden form elements, but it is not storing in the database, then I would double check that the subscribe date and expiry date column are bound to the hidden elements in the insert record behavior.


if you need further assistance I would need a copy of your page in a zip archive to examine the code

Hi Jason,
See the attached zip file. In addition to the above on date, I cannot get the 'agree to terms' checkbox to validate

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.