What's wrong with my cfoutput group?

2008-12-01 Thread Will Tomlinson
I don't recall ever having a problem with the cfoutput group attribute. But I can't figure out why it isn't woring right here. My table looks like this: ID Date ZIP code - 1 12/01/200827403 2 12/01/200890210 3 12/01/2008

Re: What's wrong with my cfoutput group?

2008-12-01 Thread Will Tomlinson
Crap, it goes back to my stupid date/time datatype for the field. All the times are different, and CF IS group the data, but they're all different so it output each row. I used Michael's example from my other thread to do this. Seems to work: SELECT estshiplogid,CAST(FLOOR(CAST(estshiplogdate