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 Link to comment https://forums.phpfreaks.com/topic/68772-solved-weekday-where-query/ 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 Link to comment https://forums.phpfreaks.com/topic/68772-solved-weekday-where-query/#findComment-345721 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.