Is Notes dynamic with respect to the system clock?

HCL Domino Domino Forum
1

I have a view selection formula which I “think” is doing what I need. My field cbrDateadjusted is a computed date +3 when it’s composed. I want the document to show in the view only when the field’s date is reached. Here’s my code:SELECT @IsAvailable(cbrDateadjusted) & cbrDateadjusted <@Today

I’ve been testing it by switching my system clock forward, and it seems to show in the view when I hit the correct date, but when I change my system clock backwards (after I hit the date and the doc’s appear), the documents stay in the view until I completely exit Notes & Designer.

Stupid ? #1: Is this because some internal Notes clock?..since refreshing the view doesn’t clear it.

Or:

Is my code flawed?

Or:

Both

Thanks for any input.

Glen

2

Subject: Is Notes dynamic with respect to the system clock? - OUCH!

…never use dateformulas in selectformulas (as well as username formulas).

this is slow, and leads to weird results.

(for previewing purposes, your problem might be solved by pressing shift+F9 to completely rebuild the view).

the problem with date- and usernameformulas in views is that the view is indexed on the server EVERY time you open it.

if another user comes along at the same time while (an)other user(s) is/are “in the view”, then they will all get (very) weird results, since notes maintains only one index for the view and not one for every user who opens it.

so, rather create a scheduled agent processing the docs whenever needed to set a flag whether they should show up in the respective view and change the view’s select statement appropriately.

hope that helps for a start,

regards, florian