Auto Calculating a date in the future

Hi guys,

I have a form now that simply has one field to enter a date and it updates the date in the table. Easy as Pie.

But I also need it to update a second field in the table with the entered date plus 180 days in the future. I can get it to enter the same date in both fields real easy (Starting to really like Data Assist) but can't figure out how to add the 180 days to it.

Ideas?

This would probably do it:

<?php echo(strtotime($_POST['yourfield'] . " +180 day")); ?>

But you could probably add the 180 days when you query it and not even use an extra field in the database if it will always be 180 days from an existing date there is really no reason to store it at all since you can use SQL to get it from the query without ever storing the field.

Thanks Ray,

Yeah I could just get the value in a Query. But in this case the way that it is being used and how often, it is just so much easier to have a second field in the table.

Mainly because it will default it to the 180 days when entering ... but yet still remain editable on a record by record basis.

Again, thanks for your help. I knew there had to be a way with Data Assist. I'll give that a try.

Brad

Well, that didn't work. It does enter a date in the field, but it enters 1/1/0001 as the date.

Any more ideas? Thanks again.

Yeah I forgot to insert into the database you need to update it to 'Y-m-d' syntax... so the code would be:


<?php echo(date('Y-m-d',strtotime($_POST['yourfield'] . " +180 day"))); ?>

Thats the ticket! That worked perfectly! Thanks again ....