Alright, didn't know that you were on Access. it's been a while since I've
used Access but I'm pretty sure that you want to parse out each part of your
date, concatenate it together and return it as a string using CStr(). The
whole SQL query would look like this.
SELECT theTitle CStr(Month(theDate) & '/' & Day(theDate) & '/' &
Year(theDate)) AS theDate
FROM theTable
ORDER BY theDate
This will return the date as a string with no timestamp on it. Performance
might suck just a little bit, but this is access after all. <G>.
Hope this helps,
--
Jeff Garza
_____
From: Jake . [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 04, 2004 5:09 AM
To: CF-Talk
Subject: Re: Grouping help
Not sure if that would help. I'll have to check it out, since I'm using
Access. Thanks!
>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]
