Search code examples
lotus-noteslotus-dominolotus-formula

How do I select all documents that creation date equal or less than the today?


I would like to select all documents that the creation date equal or less than the actual date(Today), how do i go about this.I have a view selection formula

@Select Form="Memo" & @Adjust(@Created; 0; 0; 0; 0; 0; 0)<= @Today

Solution

  • You were close:

    @Select Form="Memo" & @Date(@Created) <= @Today
    

    The problem is, though, that ALL documents will ALWAYS have been created today or earlier. :)

    Perhaps you want all documents that were created prior to a certain date?

    @Select Form="Memo" & @Date(@Created) <= @Date(2016, 7, 7)