I have a database with the date field in it and I was wondering how i could use the select statement to get dates from a certain range(to be simply from one month). I tried using SELECT...WHERE thedates >= 1-1-1980 and thedates < 2-1-1980

but it didnt seem to work. Any suggestions?

thanks