try: Delete from DealerAuditTable Where DateRecordAdded < #DateAdd(d, -2, now()) ~Simon -----Original Message----- From: wpdd [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 1: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> </DIV> <DIV><FONT face=3DArial size=3D2>I'm trying to delete all records = that are more=20 than two days old </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 </FONT></DIV> <DIV><FONT face=3DArial size=3D2><BR> Delete from=20 DealerAuditTable<BR> Where DateRecordAdded &nb= sp;<=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.
