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
~|
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
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
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
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
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:
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
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
8 matches
Mail list logo