I'm using date format in the CFOUTPUT area. However, I need to filter the
query select statement so that it does not return the time - then I can
group by date, regardless of time on a particular date.
Thanks,
Mark
-----Original Message-----
From: Dave f [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 9:43 AM
To: CF-Talk
Subject: Re: Excluding Time in Date/Time db Query
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
