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)