How can I grab the min pic and max pic by the date entered?

I have a script that loads two pics at once and saves them as individual files. What I am trying to do is grab them individually using min(), max() where date_entered. But, I get the error "You tried to execute a query that does not include the specified expression 'date_entered' as part of an aggregate function." HEre is my code"

<cfquery name="getSire" datasource="#application.database#">

select date_entered, max(pic) as topPic from litters

where date_entered = '7/19/2013'

</cfquery>

How can I select the min picture and the max picture by the date it was entered?