Maybe ParseDateTime() would save you some time.
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 4:23 PM
To: CF-Talk
Subject: Sort by 1st three letters of month?
Ok, I'm an idiot. I have my users putting in text strings for months.
I need
Ja
.
-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 9:59 AM
To: CF-Talk
Subject: RE: Sort by 1st three letters of month?
There is no need to do this in ColdFusion. Your database is able to convert
the month numbers
nd it works.
Of course this calls for having seperate fields for month, day, date.
Guy
www.guymcdowell.com
>--
>
>Date: Wed, 01 Aug 2001 00:33:11 -0600
>From: "Kwang Suh" <[EMAIL PROTECTED]>
>Subject: RE: Sort by 1st three letters
this calls for having seperate fields for month, day, date.
Guy
www.guymcdowell.com
>--
>
>Date: Wed, 01 Aug 2001 00:33:11 -0600
>From: "Kwang Suh" <[EMAIL PROTECTED]>
>Subject: RE: Sort by 1st three letters of month?
>Message-ID:
Cast the text strings to a date within your SQL query. Then, you can easily
sort by month.
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: July 31, 2001 2:23 PM
To: CF-Talk
Subject: Sort by 1st three letters of month?
Ok, I'm an idiot. I have my users putting in te
you could set up an array,structure, or a new DB table with 1,jan .. 12 ,dec
"Willy Ray" <[EMAIL PROTECTED]> wrote:
Ok, I'm an idiot. I have my users putting in text strings for months.
I need
Jan. 12
to be ordered ahead of
Aug. 9
These are text records. Is there any way to do this? I g
6 matches
Mail list logo