jonnyboyo
Posts: 15
|
| Posted: 03/24/2006, 7:33 AM |
|
I have a MYSql database with 5000+ articles and a search page with the facility to search between dates. It works perefectley until I try to search between 2005 and 2006 when it gives 0 results.
Anything in 2005 or anything in 2006 and it works like a dream, but go across the 2 years and nothing.
I'm searching on a Searchdate field in the format mm/dd/yyyy which is converted back to dd/mm/yyyy for the date picker. I've also got a timestamp date ( mm/dd/yyyy h:nn:ss AM/PM ) and an article input date in the dd/mm/yyyy H:nn:ss format.
I've tried every combination on each field without success. If anybody can explain how to do this or where I'm going wrong it will much appreciated.
I'm using CCS 3.0.22 MYSql and Asp 3 with templates
|
 |
 |
|
