Assistance needed with formula for a Lotus Notes view
Posted on 2002-07-15
I am working on a view in Notes [4.6a] and am having trouble with a formula. The formula I have now is:
SELECT Form="Sample Login"&deliver!="China"&(DateReceived>=[07/01/2002])
Which works well, but the manager wants a little more added to it...
Specifically, I need to NOT display any records that have "completed" or "released" in the Status field - but after 2 weeks from todays date...
So if today is 7-1-02, then on 7-14-02 I would expect all records that have 'Released' or 'Completed' NOT to be displayed.
I think the pseudo-code would something like:
IF status ="Released" or "Completed" AND (CompletionDate + 14 days) <= Today THEN display information
ELSE IF status="Released" or "Completed" AND (CompletionDate + 14 days) > Today THEN do not display information.
The only advice I've received thus far says I will need an agent for the date calculations, which I hope isn't true since I have no experience at all with agents.
If anyone can provide any insight into this I would be VERY grateful!
Thanks in advance!!