We are running a report to pull a day range from our database. The problem we are having at the beginning of the month isthat when I put the day range the report pulls all the dates with those numbers in them, where we just want theday. So if we pull days from 2-5 we get all the days with a 2,3,4,5 in them (including 21, 31 etc.) is there any way to not get days except for the single day range?

This is the query we are using:
SELECT
cb_francsicansister AS _, firstname AS Name,
cb_fdmonth AS Month, cb_fdday AS Day
FROM
joom_comprofiler
WHERE
cb_fdmonth = {$REQUEST:start|empty:''}
AND
({$REQUEST:start2|empty:''} = '' OR cb_fdday >= {$REQUEST:start2|empty:''})
AND
({$REQUEST:End2|empty:''} = '' OR cb_fdday <= {$REQUEST:End2|empty:''})
ORDER BY
cb_fdday ASC

Hello,

What type of "cb_fdday" column? Is it integer?

Regards,
ARI Soft

Looks like type:text

Cast it to an integer type.

Regards,
ARI Soft

Thanks! Appreciate the fast help! That fixed it!