You'll have to used a dateadd with now and "d" and negative fourteen as parameters.
then do a createodbcdate on that..
CF is really good for this type of thing.
Jared.
"Parker, Kevin" wrote:
> Haven't tried this - but can you do maths inside a query e.g.
>
> WHERE StartDate <= CreateODBCDate(Now()-14) to get records from 2 weeks ago
>
> ********************************
> Kevin Parker
> Service and Communication
> WorkCover Corporation
>
> [EMAIL PROTECTED]
>
> ph: +61 8 82332548
> fax: +61 8 82332000
> ********************************
>
> -----Original Message-----
> From: Johan Coens [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 31 July 2000 4:53:PM
> To: [EMAIL PROTECTED]
> Subject: RE: Need help from a pro
>
> Try CreateODBCDate(Now()) Like:
> ...
> WHERE StartDate <= CreateODBCDate(Now())
> AND EndDate >= CreateODBCDate(Now())
>
> R. Johan
>
> -----Original Message-----
> From: Mike Weaver [mailto:[EMAIL PROTECTED]]
> Sent: zondag 30 juli 2000 8:08
> To: [EMAIL PROTECTED]
> Subject: Need help from a pro
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0028_01BFF9B1.CB80B280
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hello,
> I am in need of guidance on dates. I am using an Access db. and =
> have a query which generates records between 2 dates you enter in a =
> form. The date input for each record is the automatic access db =
> function.
>
> I can't seem to get the #DateFormat(Now())# to work in single or double =
> quotes so I used the auto function. When I run the query I get an error =
> of division by zero.
>
> Any assistance is greatly appreciated.
>
> Mike
>
> ------=_NextPart_000_0028_01BFF9B1.CB80B280
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2> I am in need of guidance =
> on=20
> dates. I<EM> am using an Access db. and have a query =
> which=20
> generates records between 2 dates you enter in a form. The date =
> input for=20
> each record is the automatic access db function.</EM></FONT></DIV>
> <DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV>
> <DIV><EM><FONT face=3DArial size=3D2>I can't seem to get the =
> #DateFormat(Now())# to=20
> work in single or double quotes so I used the auto function. When =
> I run=20
> the query I get an error of division by zero.</FONT></EM></DIV>
> <DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV>
> <DIV><EM><FONT face=3DArial size=3D2>Any assistance is greatly=20
> appreciated.</FONT></EM></DIV>
> <DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV>
> <DIV><EM><FONT face=3DArial =
> size=3D2>Mike</FONT></EM></DIV></BODY></HTML>
>
> ------=_NextPart_000_0028_01BFF9B1.CB80B280--
>
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
>
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
>
> ****************************************************************************
> This e-mail is intended for the use of the addressee only. It may contain
> information that is protected by legislated confidentiality and/or is
> legally privileged. If you are not the intended recipient you are prohibited
> from disseminating, distributing or copying this e-mail. Any opinion
> expressed in this e-mail may not necessarily be that of the WorkCover
> Corporation of South Australia. Although precautions have been taken, the
> sender cannot warrant that this e-mail or any files transmitted with it are
> free of viruses or any other defect.
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and destroy the original e-mail and any copies.
> ****************************************************************************
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.