View selections by formula language

HCL Domino Domino Forum
1

In view selection , if we want to get those documents created in last 30 days , we write :

date created is in the last 30 days by Simple Search.

How can I write the above condition in Formula Langauge??

I tried this as:

(@Created >= @Adjust(@Created;0;0;30;0;0;0)) but it doesnt work.

Any idea??

Regards,

Aisha Ishrat.

2

Subject: View selections by formula language

Aisha,

There is some problem in the logic of your view selection formula.you formula is:

(@Created >= @Adjust(@Created;0;0;30;0;0;0) )

here you are trying to get document which are >= @created , but @created returns creation date and time of each documet.Hence it is not a constant value.

You should search agaist a value which is constant for every document ,like @now or @today.

your formula shuld be.

(@now>= @Adjust(@Created;0;0;30;0;0;0) )

or

(@Today>= @Adjust(@Created;0;0;30;0;0;0) )

I think you have got my point.

“Have a nice weekend”

Anand Saraf

3

Subject: RE: View selections by formula language

Yups got it.I have done this as:

(@Created >= @Adjust(@Now;0;-1;0;0;0;0))

Thanks a lot.

Regards,

Aisha Ishrat.