Mysql Search Range

[Anon]

Hey Folks,

I searched for a way to do a search on a certain range, and found a couple ways to do it. However its not working right... Here is what I have

SELECT * from SOMETABLE where PROBLEM_ID >= "$start_date" and <="$end_date"

If I have a problem logged for

20011129-01:20:33

and I enter the dates of
2001-11-28
to
2001-11-29

It won't find it... however if I do the end date of 2001-11-30 it's able to find it! I'm not understand why when Im using less/greater than or equal.

Any ideas?
Thanks

[veron]

2001-11-29 is interpreted as 20011129-00:00:00, so 20011129-01:20:33 is actually greater and outside of the range you specified.

[Anon]

Ok, I made my end date seach add +1 so it will actually search for the next day and it seemed to fix that problem, but now I'm running into other problems with the searching for dates!!!

How would you recommend I search? Should I enter the date just into a new field and just have it enter like

2001-11-29

so later I can do the search correctly? or enter it some other way?

What I'm doing is, someone will create a problem ticket, the date and time becomes the problem ID number... Example
20020123-11:54:00 would be a problem ID number if I created a ticket right now. Then they close it and I move everything into another table called Archived_problems so I can search on them.

The way I'm searching is the <= and => with the customer specifing the date and I convert it from 2002-01-23 to 20020123 and search that way but I'm running into so many problems.

Any help would be great!

thanks