Re: date comparison

On Wednesday 21 August 2002 21:28, Smita Manohar wrote: > hello, > in my script i want to compare input date with date stored in database and > want the result for date <= input date and sometime for date >= input date. How is the date stored? What type of field? > it didn't work for <= and >= operators. i also tried using "between" but > it > didn't give desire result :-( How are you doing your comparison? As php code? As sql query? > is there any other comparison operator to be used for date??? <, <=, >, >= can all be used if your data is in the correct format. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Oh, yeah, life goes on, long after the thrill of livin' is gone. -- John Cougar, "Jack and Diane" */