Hi Mike,
I think you want the DateDiff function, where the result is less
than -30 (when the result is expressed in days).
Cheers,
Peter
-----Original Message-----
From: [email protected] On Behalf Of Mike Belcher
strSQLstringDelete = "DELETE FROM Winks WHERE [t_username] = '"
& strWinkOwner & "' AND [WinkDate] Between DateAdd(""d"",-30,Date()) And
Date()"
Hi guys and gals. Above is a string to delete records between the date
NOW and 30 days before but what I am trying to do is delete any record
that is older than 30 DAYS. I am not great at the date stuff in SQL
strings can anyone tell me how I would modify the end of this string?
Thank you.
Mike
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
