--------------7673C97E063B4ACB60084DC7
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Of course it is possible. It would be something like this:
---------------
select whatever_field
from your_table
where your_date_field >= #your_variable_date#
------------------
Be sure that you format your variable date to odbcdate before you put in the query..
Tim Bahlke wrote:
> I want to be able to search my DB by anything added since mm/dd/yyyy date.
> So, I am hoping I can say in my query ... WHERE
> Personal.DateEntered>=04/28/2000, for example.
>
> Is this possible?
>
> ------------------------
> Tim Bahlke
> Graphica
> www.thinkcreate.com
> P: 336.230.0575
> F: 336.230.0083
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Nathan Chen
(208)-426-8470
Computer Control Systems, Inc.
--------------7673C97E063B4ACB60084DC7
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Of course it is possible. It would be something like this:
<br>---------------
<br>select whatever_field
<br>from your_table
<br>where your_date_field >= #your_variable_date#
<br>------------------
<p>Be sure that you format your variable date to odbcdate before
you put in the query..
<br>
<p>Tim Bahlke wrote:
<blockquote TYPE=CITE>I want to be able to search my DB by anything added
since mm/dd/yyyy date.
<br>So, I am hoping I can say in my query ... WHERE
<br>Personal.DateEntered>=04/28/2000, for example.
<p>Is this possible?
<p>------------------------
<br>Tim Bahlke
<br>Graphica
<br>www.thinkcreate.com
<br>P: 336.230.0575
<br>F: 336.230.0083
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
<p>--
<br>Nathan Chen
<br>(208)-426-8470
<br>Computer Control Systems, Inc.
<br> </html>
--------------7673C97E063B4ACB60084DC7--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
