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