I'm sure at least one of you people have had this problem, and i'm pulling
my hair out of here....

I have a field which has a date/time value.

ie :  4/3/2001 12:00:00 PM

now there are tons of records for each day, but with different times.  

I am trying to output a list of the past 10 days.  Grouped by the Day only,
not the time.  

I've tried to actually format the date field in my [group] functions in the
cfoutput like this...

<cfoutput query="information" group="DateFormat("#information.Date#",
"m/d/yyyy")#">

but this gives me an error saying that the information in the query does not
match within the loop....

Can someone help me on this one?  I feel as though there is a really simple
answer, though i am clearly not seeing it....

Thanks.

Kevin

~~~~~~~~~~~~~~~~~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to