gevensen Posted August 14, 2009 Share Posted August 14, 2009 I have a working query SELECT * FROM sc_income WHERE ( full_name = 'Allig, Emily' AND service_date BETWEEN '2009-1-1' AND '2009-2-1' ) the problem i am having is a record from 2009-1-4 ( date taken from table ) will not show up if i query BETWEEN '2009-1-1' AND '2009-1-31' any ideas as to why this might be once i query BETWEEN '2009-1-1' AND '2009-2-1' it shows up???? Quote Link to comment https://forums.phpfreaks.com/topic/170262-solved-between-query/ Share on other sites More sharing options...
gevensen Posted August 14, 2009 Author Share Posted August 14, 2009 ok i figured it out i had to redo the tables it only seems to work with 2009-01-4 not 2009-1-4 the 0 being on the trailing edge of the month Quote Link to comment https://forums.phpfreaks.com/topic/170262-solved-between-query/#findComment-898204 Share on other sites More sharing options...
fenway Posted August 21, 2009 Share Posted August 21, 2009 That's shouldn't have mattered... where these proper DATE fields? Quote Link to comment https://forums.phpfreaks.com/topic/170262-solved-between-query/#findComment-903195 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.