Link to home
Start Free TrialLog in
Avatar of j8547
j8547

asked on

Select Logic and Dates

I have a database the lists jobs, their start dates, admin dates, production dates, ship date and finish date. My webpage display the job name, start date and then the status of the next 5 days. If the data is between start and production then its in Admin stage, between production and before ship date, then in production stage and so on.

It looks like it is working but not all the status is wrong. The logic in the Select looks correct but it is just not working. If i change the select to be (true) which I think it should be then it totally messes it up. I thought I had all the dates formatted the same way but not sure if this is throwing my logic out. I just can't figure it out. Any help appreciated.
Database.jpg
Display.jpg
Index.php
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial