Comparing dates in text field

2008-05-30 Thread Joy Paulose
Hi guys, I need to select a date range and find min and max value from another field based on the dates provides. The problem is that the dates are in a varchar field in SQL. Is there any way to solve this task? Thanks Joy ~|

Re: Comparing dates in text field

2008-05-30 Thread Gerald Guido
Are they dates as in when you do a isDate() they return true? If you can get them to be valid dates you do date manipulation even if they are stored as strings in the database.. I have dealt with this before. Not fun. But do-able. G On Fri, May 30, 2008 at 10:59 AM, Joy Paulose [EMAIL

Re: Comparing dates in text field

2008-05-30 Thread Joy Paulose
Gerald, I am able to get them as a valid date. But if we can do a query of query using a min and max function, that would be great. Jo Are they dates as in when you do a isDate() they return true? If you can get them to be valid dates you do date manipulation even if they are stored as strings

Re: Comparing dates in text field

2008-05-30 Thread Phillip Vector
I know you've probably been asked this question before... but why do you have dates stored in a varchar field? On Fri, May 30, 2008 at 7:59 AM, Joy Paulose [EMAIL PROTECTED] wrote: Hi guys, I need to select a date range and find min and max value from another field based on the dates

Re: Comparing dates in text field

2008-05-30 Thread Gerald Guido
I think you can cast them as dates using SQL. I don't know the syntax off the top of my head nor have I done it. Perhaps some one can put forth some code. What DB are you using? but why do you have dates stored in a varchar field? In my case it was the person before me. On Fri, May 30, 2008

Re: Comparing dates in text field

2008-05-30 Thread Joy Paulose
I don't know. It has been done by somebody before me. J ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive:

Re: Comparing dates in text field

2008-05-30 Thread Phillip Vector
On Fri, May 30, 2008 at 8:42 AM, Gerald Guido [EMAIL PROTECTED] wrote: but why do you have dates stored in a varchar field? In my case it was the person before me. Gotta love developers like that. :) It may save headaches later to instead of trying to code around it, just make a new field

RE: Comparing dates in text field

2008-05-30 Thread Brad Wood
Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2008 10:43 AM To: CF-Talk Subject: Re: Comparing dates in text field I think you can cast them as dates using SQL. I don't know the syntax off the top of my head nor have I done it. Perhaps some one can put forth some code