Re: Options when it comes to searching dates?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 05/12/04 

Date: Wed, 12 May 2004 07:14:13 -0700

Raterus,
Can I assume that you are referring to free-form date formats, such as
"4/12/04", "May 11th, 2004", "February 12th", "2004/05/01", et al. and then
being able to take any two of these date formats and determine the
difference in days and return all matching records within that date range?
Correct?

Assuming I'm correct in the above assumption, SQL FTS and Indexing Service
cannot out-of-the-box provide this type of functionality. However, if you're
able to intelligently parse the textual data and then put the above date
formats in SQL table columns define as int datatypes, then this is possible.
However, it does require a significant amount of programming to detect and
parse all possible date formats and put them in the correct columns.

So, while you are not dreaming, it is possible, but difficult.
Regards,
John

"Raterus" <raterus@spam.org> wrote in message
news:#a85eZCOEHA.2780@TK2MSFTNGP09.phx.gbl...
Are there any options available in queries that are searching textual dates
that have been indexed? Perhaps the ability to specify a range and all
matching records would be returned? Am I just dreaming? :-)