Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Add days to timestamp date from recordset

Add days to timestamp date from recordset

Thread began 9/24/2010 12:07 pm by bill173836 | Last modified 9/24/2010 12:41 pm by Jason Byrnes | 1593 views | 5 replies |

9/24/2010 12:07 pm | #1 bill173836

Add days to timestamp date from recordset

I'm trying to display a date that is 4 days after the timestamp date in my database this will be an expiration date. I keep getting an error anybody see what I'm doing wrong? Thanks.

<?php $NewDate = (($row_WADAfunkycouponsused['printdate'])"+4 days"); echo $NewDate; ?>

9/24/2010 12:18 pm | #2 Jason ByrnesWebAssist

try this instead:

php:

<?php $NewDate = (strtotime($row_WADAfunkycouponsused['printdate']."+4 days")); echo $NewDate; ?>

9/24/2010 12:23 pm | #3 bill173836

This is what it the code you sent returns:
1285686965

This is what is stored in the database:
2010-09-24 08:16:05

9/24/2010 12:28 pm | #4 Jason ByrnesWebAssist

you have to convert it to a time stamp to add days, use date to convert it back:

php:

<?php $NewDate = (strtotime($row_WADAfunkycouponsused['printdate']."+4 days")); echo date("Y-m-d h:m:s", $NewDate); ?>

9/24/2010 12:38 pm | #5 bill173836

Perfect, Jason you are the man!

9/24/2010 12:41 pm | #6 Jason ByrnesWebAssist

you're welcome.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.