Of course i'm agree with you, but i write the date like i do just for example but i know how you write is the correct way.

In that case not work, i says if you us on the where section like this.

Select * from table

where date between '12-12-12' and '12-31-12'

This will do the same you have in the where section, go from day 25 to 29. Give it a try,i used before and works great.

you can replace this part of the query

"Last_Status_DT >= '2013-10-25'

AND Last_Status_DT < '2013-10-29';"

For this one

"Last_Status_DT between '2013-10-25' and '2013-10-29';"

And the...