Jump to content


Photo

Doing math with DATE


  • Please log in to reply
1 reply to this topic

#1 jester626

jester626
  • Members
  • PipPipPip
  • Advanced Member
  • 39 posts

Posted 30 July 2006 - 05:42 PM

This is a PHP/MySQL question of sorts. I have a field called FollowUpDate in the DB. What I want to be able to do is to do some math in PHP that will show me a record when it is within 7 days of the follow up date. My DB field is of the DATE Type (YYYY-MM-DD) and for the life I me I can't figure out how to pull the data out as I need it.

Any help would be greatly appreciated
As the old saying goes. "What does not kill you, makes you stronger". I prefer "What does not kill me, DIES!!!!!!!

#2 legohead6

legohead6
  • Members
  • PipPipPip
  • Advanced Member
  • 434 posts

Posted 30 July 2006 - 05:47 PM

pull it out so its in a variable called $date then go echo"date(formathere, $date)";
"Syntax error" .. WHERE THE **** IS IT?!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users