no record in result set:

select count(*),today_date from szallodaossz.fdday_status_room where (today_date between
"2005.10.13" and "2005.11.12") group by today_date



but this select works correctly (30 records):

select count(*),today_date from szalloda.fdday_status_room where (today_date between
"2005.10.13" and "2005.11.12") group by today_date

or

select count(*),today_date from szallodaossz.fdday_status_room where
(today_date>="2005.10.13") and (today_date<="2005.11.12") group by today_date