Notes/Domino 4 and 5 Forum

Hi Everyone

I know there are loads on entrys on this forum about renaming fields, but I can't find one to suit my needs (I have looked - honest!).

I have an agent already set up (runs from lotus script) which generates a form for each person each month. The document status is set to Raised when it is created.

I would like to set up an agent which changes the status from Raised to Overdue after 7 days. I have set up the agent below but it doesn't work.

Days := (@TextToTime(@Text(Created)) - @Today) / 86400;

@If(DocStatus="Raised" & Days= -7;@SetField(DocStatus;"Overdue");"");SELECT @All

Does anyone have any ideas? (I'm using 4.6)

Thanks
Jenny