[thelist] CF: grouping output by date & Access

[Frank]

<tip type="Cold Fusion" author="Frank Marion">
I wanted to group some articles by publication date. Easy: group by date, 
right? When using MS Access, the field type is date/time. If one use's 
Access's Now() function as the default for the field, every record will be 
different, because they will all be inserted at different times, defeating 
the ability to group by date. The solution is to insert an ODBC date 
programmatically. If no time is specified, access will still include a 
time, but will default to 00:00:00
</tip>