dates leave me in a bad state

[gavray]

I'm trying to a retrieve records that are between between 2 dates

SELECT * FROM TABLE
WHERE Dateposted >= '2001/5/1' AND Dateposted <= '2001/5/31'

Well this works fine for records 2001/5/10 upwards but a date like 2001/5/8 is not brought up even though it's there in the database.

I've tried putting the date all different ways and with 08 and 05 it still doesn't work.

Please, Please is there a way out of this quandrey

Gavin

 

[Mighty]

Are the dates stored in datetime format or are they stored as strings. From what you are saying, it would seem that there are stores as strings as 2001/5/8 would be greater than 2001/5/31 if they were strings.

You need to convert the dates to date format before you compare them. Mise Le Meas,

Mighty

 

[gavray]

thanks

yes durrrH! the field in the database wasn't set to date/time small format

mad!