Have you tried DateFormat()
----- Original Message -----
From: "Mark Leder" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 2:12 AM
Subject: Excluding Time in Date/Time db Query
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
