pauldavidbrown

The format in mysql is YYYY-MM-DD

Most recently, I have tried this... $Today = date('m/d/Y'); $Days = date_diff($Today, $row('CloseDate')); echo $Days->format('%R%a days'); But -- I cannot get it to even display the # of days in that format and am therefore stuck. I'm guessing it is because the two are not in the same date format. I've also tried $Today = new DateTime("now"); -- but it yields the same results.

I'm sure this is super simple, I just can't figure it out. I have a php page that accesses a mysql database and shows the date closed. I simply want the page to display the date in black by default, green if 30-60 days past (from current date), orange if 60-90, and red if over 90. The Structure of the CloseDate field is just a date field within mysql. This runs on a bluehost server with all current php and mysql versions. Any response is sincerely appreciated. See attached screen shot.