using cfquery results in cfmail

Hello

I have implemented a blog using the blogcfm application. I
want to mail the summary which consists of the blog topic and all
the comments for a particular day to all the users of the blog once
a day. I was trying somthing out using the cfquery and the cfmail
tags but I am not able to select records just for the current day
and mail those to the users. Can anyone suggest how do I go about
doing that? Thanks in advance..using cfquery results in cfmail
Were you at least able to select records for the current
day?