Search code examples
lotus-noteslotusscriptlotus

How to use lotusscript NotesDateTime object in search formula in Search method of NotesDatabase?

I want to use NotesDateTime object in search formula of search method of NOtesDatabase. Below is my code

Dim searchFormula5 As String
Dim modifiedAfter As New NotesDateTime("10/10/2010")
searchFormula5$= {PaPeriodEnd<@Today & PaPeriodEnd > modifiedAfter & PaStatus=Signed }  
Set collectionDocs=database1.Search(searchFormula5$,NOTHING,0)

I am not able to use modifiedAfter in search formula. PaPeriodEnd is date item in documents in the database.

Solution

  • Try it searchFormula5$ = {PaPeriodEnd < @Today & PaPeriodEnd > [10/10/2010] & PaStatus = Signed}