Hi All,
I have a list of log dates in a column. I want to select this dates using a search form that have 2 fields which are date_start and date_end. For example, the column have this lists :
13/02/2004
18/02/2004
27/02/2004
And I select date_start = 10/02/2004 and date_end = 20/02/2004. So, it should return me 13/02/2004 & 18/02/2004 right? So, how do I do this? Please advice.
Subject: RE: Date Search
You could construct a query to use FTSearch method. Something like this:
strQuery = "[logDate] >= " & date_start & " and [logDate] <= " & date_end
count& = view.FTSearch(strQuery, 0)
However, what you do with the search results is a different question. There’s not really a good way to display the view showing just the matching documents. This has been discussed here and in the Notes 4/5 forum.