Hi

Using a COMMAND (Stored Procedure) in UD4 how would I delete all records over 18 months old that are not in a certain category? It's the format of the date i'm fumbling with.
Was thinking of this (assuming that 18 months is 550 days)

<b>DELETE FROM messages
WHERE ((messages.fldPosted&lt;Date()-550)) AND messages.fldCategory &lt;&gt; 'FOUND'</b>

how does that look??

thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

hi

that works fine ( I think<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome