Group output on date

hi all,

 

i have series of records stored in access table, each of them including date/time.  attempting output records grouping them on date/time column, because each time unique, separtate group each record. possible in cf query eliminate time , pull date info?  if so, how?  example, want records dated 3/15/2013 grouped, instead of 5 different records 3/15/2013 grouped 5 different ways because of varying times.

 

thank in advance!

when run query, add string constant select clause.

 

select blah, blah, mydatetimefield, 'update later' groupfield

from etc

order mydatetimefield

 

then loop through results , use querysetcell set groupfield dateformat(mydatefield, 'mask of choice').

More discussions in ColdFusion

adobe