Manage Learn to apply best practices and optimize your operations.

@today in view selection formulas

By now you all must know that using @Yesterday, @today ,@tommorrow in column or selection formulas impacts the efficiency of your application.

View member feedback to this tip.

By now you all must know that using @Yesterday,@today ,@tommorrow in column or selection formulas impacts the efficiency of your application. It also causes the view refresh indicator to display constantly because every time the view is opened it creates an index.

Here is a solution:

Select Form="frm_birthday" and dt_birth=@texttotime("Today")

This view will show all of the employee documents whose birthdays are today, because Notes internally interprets "Today" as today's date and does not create an index each time the view is opened.

Note: "Today", "Tomorrow", and "Yesterday" are the only legal strings to use to represent relative date.


I was very excited to find this tip, since I had several database views that require use of @Today and they were very slow to open. I modified the view formulae using the tip, and they opened much more quickly. However, I got a call today from a user complaining that her followup view did not appear to include all the documents that she was supposed to follow up on. It appears that the view does not get updated with Updall or with a view refresh. When I rebuilt the view index, a lot of additional documents appeared in the view. This was true for all the views whose selection formulae I had changed. Since there is not easy way of doing a Shift-F9 to rebuild a view programmatically, this approach appears to rely on the users knowing that they should rebuild the views manually. If anyone knows of a way of getting the views rebuilt automatically, it would be very helpful.

—Liz S.

Do you have comments on this tip? Let us know.

This tip was submitted to the tip exchange by member Hemang Kapadia. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Dig Deeper on Lotus Notes Domino Formula Language



  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...