Agent to sendmail when doc older than 365 days

Am I missing something here? I have a VERY simple agent to send an email to the creator of a document if that doc is older than 365 days. I have used SIMPLE search builder. Code: ReviewDate is older than 365 days. But none of my docs get selected and I know many are older than 365 days. If I change to older than 1 day I get some docs, which I shouldn’t get. Is this an R6 date thing? Also send doclink doesn’t work - special database object error message.

TIA

Subject: agent to sendmail when doc older than 365 days

First thing to do is to examine the contents of your ReviewDate fields. Do the documents in question have a ReviewDate field? Is the date as far back as you expect it to be? For the second part of the problem, we’d probably need to see the code.

Subject: agent to sendmail when doc older than 365 days

thoughts: check whether reviewdate is time-date

agent set to process all docs only once

full-text index

I suspect the first idea.

Subject: For problem 2, you must have…

a “default” view: