Walter, You are grouping by dateSigned which ensures that the min() and max() will be the same (because you get a new record for each value of dateSigned).
Remove dateSigned from your select statement and your group by statement and see if your results make more sense. Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ ><cfquery name="getSigs" datasource="firme"> >select signerName, signerLocation, signerComment, dateSigned, >MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate >from signatures >where signatures.petId ='#id#' >group by signerName, signerLocation, signerComment, dateSigned >order by dateSigned desc ></cfquery> > >returns the same (MAX) date for MIN and MAX even though the date range is >ample. >The error is laughing at me but I cannot see it. >Thanks for helping. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
