Re: Options when it comes to searching dates?

From: Raterus (raterus_at_spam.org)
Date: 05/12/04 

Date: Wed, 12 May 2004 10:30:32 -0400

Can you give me a little more detail about storing the dates as int's, or just how I would use a full-text query to specify a range. In my application I know the dates stored will be in this format "4/12/04", but that could be changed, as it doesn't necessarily have to be stored like that, just displayed like that.

"John Kane" <jt-kane@comcast.net> wrote in message news:%23XComtCOEHA.204@TK2MSFTNGP10.phx.gbl...
> 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? :-)
>
>