>If you are using dates to group by, make sure to get rid of any extraneous
>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?
>
>
> _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
