Search code examples
formulalotus-noteslotus-dominolotusscript

Getting documents of last 25 minutes with formula and lotusscript

In lotus I have a view with order documents. I am building an agent to search for all orders which are modified in the last 25 minutes.

For this I have done code like:

strFormule = "Form=""Order"" & @Modified >=  @Adjust(@Today;0;0;0;0;-25;0) & Deleted !=""J"""

Set ndcOrder = currentDB.Search( strFormule, Nothing, 0 )
If ndcOrder.Count <> 0 Then
Set doc = ndcOrder.GetFirstDocument
While Not doc Is Nothing

So if it is 11.00 then it need to take orders which are modified today from 10.35

But in the debugger I also get orders which where modified 2 hours earlier.

How is this possible?

Solution

  • I think it's might be because you're using @today which doesn't have a time element. Try @Now instead ?