SQL question

[Arc]

What would be the SQL to get all records on or between 2 dates...

Like if i had 2003-01-01 and 2003-12-31 and i wanted to get all records on or between those 2 dates.

SELECT * FROM tblStuff WHERE StuffDate >= 2003-01-01 AND StuffDate <= 2003-12-31

Is that right?

Thanks! 😃

[J_ystick_FI]

You can use BETWEEN comparison operator as well ..

http://www.mysql.com/doc/en/Comparison_Operators.html

😃 J@ystick_FI😃

[Arc]

that worked..thanks alot.