I need to group dates of this format for example: 04/15/2004, 4/21/2004, 4/30/2004 on a seperate page. A dropdown would enable users to drill thru what months they need.
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 11:20 AM
To: CF-Talk
Subject: RE: Query date
Robert Orlini said:
>
> I need to compare date ranges of this format: 00/00/0000.
Which format is that? dd/mm/yyyy or mm/dd/yyyy?
> If the dates in my column are lets say 04/15/2004, 04/20/2004, then
> these dates are to be listed in another page.
>
> How can I use the Where statement to group dates in this format? Or
> is there a better way in the Select?
Grouping is done using GROUP BY, not using WHERE. I'm afraid I am
going to need a less cryptic question to be more specific.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
