compare dates in asp

[olegflute]

How can I compare dates ? For example, I want to delete item IDs that have dates before or equal the current date, i.e
if rs(&quot;Date&quot <= Date then
rs.Delete

What is the correct code(condition) to compare dates?

 

[Tarwn]

You could actually handle this in a seperate SQL statement so that you would not have to loop through all of the records yourself doing the date check. Something like:

sqlStr = &quot;DELETE FROM TableName WHERE DateFieldName <= '&quot; & FormatDateTime(Now,2) & &quot;'&quot;

Then you could just execute this with an open connection. The advantage of moving this to the database to do the work is that it is going to handle the deletions faster than doing them one record at a time directly in your ASP script.

-Tarwn

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/