Re: delete records that are more than two days old

wpdd Mon, 16 Oct 2000 10:56:24 -0700
tried that it did not work

----- Original Message -----
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 16, 2000 1:30 PM
Subject: RE: delete records that are more than two days old


> Try this:
>
> Delete from DealerAuditTable
>   Where DateRecordAdded   <  #DateAdd('D', -2, now())#
>
> Larry Juncker
> Senior Cold Fusion Programmer
> Heartland Communications Group, Inc.
>
>
> -----Original Message-----
> From: wpdd [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 16, 2000 12:23 PM
> To: CF-Talk
> Subject: delete records that are more than two days old
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0099_01C03774.3F11D080
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
>
> I'm trying to delete all records that are more than two days old=20
> I'm using an access data base=20
> It allows (greater than and equal ) but having trouble with ( less than =
> )
> has any run into this =20
>
>   Delete from DealerAuditTable
>   Where DateRecordAdded   <  now()-2=20
>
> thanks Mike
>
> ------=_NextPart_000_0099_01C03774.3F11D080
> 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 content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>I'm trying&nbsp;to delete all records =
> that are more=20
> than&nbsp;two days old&nbsp;</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>I'm using an access data base =
> </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>It allows (greater than and equal ) but =
> having=20
> trouble with ( less than )</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>has any run into =
> this&nbsp;&nbsp;</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2><BR>&nbsp;&nbsp;Delete from=20
> DealerAuditTable<BR>&nbsp;&nbsp;Where&nbsp;DateRecordAdded&nbsp;&nbsp;&nb=
> sp;&lt;=20
>  now()-2 <BR></FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>thanks Mike</DIV></FONT></BODY></HTML>
>
> ------=_NextPart_000_0099_01C03774.3F11D080--
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
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.
Re: delete records that are more than two days old

Reply via email to
