I'm trying to see all employments in archives that the end date is smaller that todays date this is part of the code

<% if RsEmployment("dateoff") < Now() then %>


but its not working i have this error:

error '80020009'
Exception occurred.

/incl/employment_all.asp, line 553


I dont understand could someone tell me what i am doing wrong.

Thanks.

is the dateoff column defined as a date datatype in the database?

yes it is

Can you post a link to a text version of your code so we may have a look? That's kind of a generic error there and it would help if I could see the full source.

<%
if rsemployment("dateoff") > now() then
if strLang="e" then
response.write"<h3>Archives</h3>"
response.write "<p><a href=""/support/empl/employment_archives_e.asp"">Click here to see the archives</a></p>"

else

response.write"<h3>Archives</h3>"
response.write"<p><a href=""/support/empl/employment_archives_f.asp"">Cliquer ici pour voir les archives</a></p>"
end if
else
if strLang="e" then
response.write"<h3>Archives</h3>"
response.write"<p>There is no archives at the moment</p>"
else
response.write"<h3>Archives</h3>"
response.write"<p>Il n'a aucune archives pour le moment</p>"
end if
end if
%>

Which line is 553?

if rsemployment("dateoff") > now() then

-deleted-