RE: Verity Ordering Take 2.

2002-10-25 Thread Dave Wilson
Timothy, Not very efficient but you could perhaps convert the string to a proper date format at run-time and then sort it. Dave -Original Message- From: Timothy Heald [mailto:healdt;dsmail.state.gov] Sent: 25 October 2002 13:12 To: CF-Talk Subject: Verity Ordering Take 2. Hey,

RE: Verity Ordering Take 2.

2002-10-25 Thread Timothy Heald
Yeah I think it's going to be good old bubble sort time. Dang. Thanks, Tim -Original Message- From: Dave Wilson [mailto:dave;autosdirect2u.com] Sent: Friday, October 25, 2002 8:20 AM To: CF-Talk Subject: RE: Verity Ordering Take 2. Timothy, Not very efficient but you could perhaps

Re: Verity Ordering Take 2.

2002-10-25 Thread Jochem van Dieten
Quoting Timothy Heald [EMAIL PROTECTED]: I have 2 Verity indexes I am searching. They both contain a filed date_created, and I have added this field as custom2 to the search. I need to be able to sort by date off of that field. Now it is returning the field as a string right now

RE: Verity Ordering Take 2.

2002-10-25 Thread Timothy Heald
, October 25, 2002 8:42 AM To: CF-Talk Subject: Re: Verity Ordering Take 2. Quoting Timothy Heald [EMAIL PROTECTED]: I have 2 Verity indexes I am searching. They both contain a filed date_created, and I have added this field as custom2 to the search. I need to be able to sort by date off

RE: Verity Ordering Take 2.

2002-10-25 Thread Jochem van Dieten
Quoting Timothy Heald [EMAIL PROTECTED]: I tried query of query, but it treats it as a string, not a date. If formatted as mmdd that is not a problem. That is exactly why it is the standard dateformat, you can sort it :) Jochem

RE: Verity Ordering Take 2.

2002-10-25 Thread Timothy Heald
, 2002 9:06 AM To: CF-Talk Subject: RE: Verity Ordering Take 2. Quoting Timothy Heald [EMAIL PROTECTED]: I tried query of query, but it treats it as a string, not a date. If formatted as mmdd that is not a problem. That is exactly why it is the standard dateformat, you can sort it :) Jochem

RE: Verity Ordering Take 2.

2002-10-25 Thread Jochem van Dieten
Quoting Timothy Heald [EMAIL PROTECTED]: You are the man, I didn't even think about that. Ok, so is there a function (like convert() in SQL Server) that would let you change the date format for the whole column at once? Don't think so. But where does Verity get that date from, and can't you

RE: Verity Ordering Take 2.

2002-10-25 Thread Timothy Heald
To: CF-Talk Subject: RE: Verity Ordering Take 2. Quoting Timothy Heald [EMAIL PROTECTED]: You are the man, I didn't even think about that. Ok, so is there a function (like convert() in SQL Server) that would let you change the date format for the whole column at once? Don't think so

RE: Verity Ordering Take 2.

2002-10-25 Thread Timothy Heald
Got it. Use to_char not to_date :) Tim -Original Message- From: Timothy Heald Sent: Friday, October 25, 2002 10:05 AM To: CF-Talk Subject: RE: Verity Ordering Take 2. I am trying to do that with Oracle's to_date function, but it keeps saying that a char was found where a numeric

Re: Verity Ordering Take 2.

2002-10-25 Thread Deanna Schneider
Tim, If the field is already a date field in Oracle, you don't want to use to_date, you want to use to_date(to_char()). To_date expects a char field, so if you want to use it for reformatting a date, you have to to_char the date, then to_date it. Deanna Schneider Interactive Media Developer

RE: Verity Ordering Take 2.

2002-10-25 Thread Timothy Heald
[mailto:deanna.schneider;ces.uwex.edu] Sent: Friday, October 25, 2002 11:41 AM To: CF-Talk Subject: Re: Verity Ordering Take 2. Tim, If the field is already a date field in Oracle, you don't want to use to_date, you want to use to_date(to_char()). To_date expects a char field, so if you want to use