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