Calculate dates in view selection

HCL Domino Domino Forum
1

is it possible if i want to perform calculations in view selection?

like this

SELECT (Form = “FormName” & @Adjust(DateField;0;0;­NumberofDaysField;0;0;0) >= @Today)

I didn’t seem to be able to get it working

2

Subject: calculate dates in view selection

It’s bad idea to have a @Today, @now and @UserName in your view selection formula. The code you gave should work… But the best approach is to have an agent the runs each night that marks the documents you want to appear in the view (with a flag field of some sort) and they just have

SELECT Form = “FormName” & OldDocFlag = “1”;

3

Subject: calculate dates in view selection

It works like a charm for me.Just make sure that the ‘DateField’ is a datetype field and ‘NumberofDaysField’ is a Numeric field

PS : it is not advisable to use data calculations in view selection formulas and is a bad idea