Look into Access' FORMAT function. For operating on dates, it is similar to
DatePart, but you can use a mask such as "mmm d yyyy" to grab the entire date
part of a date/time field.
SELECT Format(myDateTimeField, "mmm d yyyy") AS myDate ...
-David
On Monday, May 28, 2001 11:13 PM, Mark Leder [SMTP:[EMAIL PROTECTED]] wrote:
> 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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
