crossfields_1 Posted September 11, 2007 Share Posted September 11, 2007 Hello all I just need a bit of help on a query, I currently have a a select statement but I need to change it to a WHERE, j.booking, CURDATE(), DATEDIFF(j.booking, CURDATE()) - (WEEK(j.booking) - WEEK(CURDATE())) * 2 AS weekdays, What this basically need to say is WHERE j.booking is less than or greater than 2 working days of CURDATE(), unfortunately I cannot do this in php and only in a mysql statement and I just need a bit of direction Thankyou Quote Link to comment Share on other sites More sharing options...
crossfields_1 Posted September 11, 2007 Author Share Posted September 11, 2007 Never mind worked this one out, just needed DATEDIFF(j.booking, CURDATE()) - (WEEK(j.booking) - WEEK(CURDATE())) * 2 <= 2 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.