I misplaced quote marks in my second query.
Instead of
date BETWEEN '2008-01-01 12:00:00.000' AND '2008-01-14 12:00:00.000' AND accomodation=1
I wrote this:
date BETWEEN '2008-01-01 12:00:00.000' AND '2008-01-14 12:00:00.000 AND accomodation=1'
Note the last quote mark after
accomodation=1:)
