Selection for view based on date

HCL Domino Domino Forum
1

I need to have a view that will only display documents that have been created within the last 15 days. I used the “simple search” option to create a view that seemed to work initially but now I can see that it is definitely off (formula below).

uses ‘PService’ form AND DateComposed is in the last 15 days

Can someone help me rewrite this in formula language. The DateComposed is a computed when composed field using @Created. I assume I will need to convert the date value to compare but I can’t figure out how to do it.

2

Subject: Selection for view based on date

SELECT form= “PService” & @Created > @Adjust(@Today;0;0;-15;0;0;0)

But remember this view will be reevaluated every time it is opened and will be very slow especially if you have many documents in your database.

3

Subject: RE: Selection for view based on date

What you have looks ok to me. In what way is it “off”? Also, what is the formula for your computed field?