I'm doing a query where I want to get values from a date/time field
(Access). I want the date (for grouping), but not the time portion.
I've tried datepart, but I would need to do several dateparts, for weekdate,
month, day and year - then I can't group by date.
Any ideas on how to write the query select statement? Is there sdth=hing I
need to do in the CFOUTPUT QUERY area?
Thanks,
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
