Hi I am trying to generate an SQL statement where the dates are between two ranges, but when I do them it works, but doesn't seem to include the last date.
i.e. so If I do this
Select * from table where datefield between '01/01/2003' and '01/10/2003'
I get between 01/01/2003 to 01/09/2003, it is missing the 01/10/2003? This is on a SQL server, should I be doing something like this?
Select * from table where datefield >= '01/01/2003' and datefield <= '01/10/2003'
Thanks in advance.