information from the datefield. If you are using SQL Server, a datetime
field will return the date, hours, minutes, seconds, and milliseconds. You
can use a CAST or CONVERT function in your SQL statement to limit what is
returned to just year, month and day.
SELECT theTitle, CONVERT(varchar(10), theDate, 101) AS dateasstring
FROM theTable
ORDER BY theDate
Would this help any?
Jeff Garza
_____
From: Jake . [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 03, 2004 10:00 AM
To: CF-Talk
Subject: Re: Grouping help
Thanks, I appreciate the help. Looks like part of my problem is (as always)
the fact that I'm using dates. Does this method work with dates?
>I have a tutorial on grouping in CF here:
>http://tutorial150.easycfm.com/
>
>Hope that helps :)
>
>Charlie
>
>
>>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
