Good morning everyone!
I had a problem to create string to do search by date in the view in LS. For example, I need to get info on 07/11/1999. I did like this:
string$ = dialogDoc.field1(0)
exp$ = "field testdate is on " + string$
j = view.FTSearch( “exp$”, 0 )
…
but it does not work. Is anybody know how to do this? Any help I appreciate!
Subject: create string to do search by date in the view
fixed.
Subject: now I wonder if you mean the eleventh of July or the seventh of November
and Notes will wonder that too. The string format needs to be that of the searching computer. If it is a server replica then the server date format is important, if it is on the client then the client format is important. The best way to find out is to have just one document in a view with a date like 01/02/00 and try to search for it. If you don’t find it then you know the format is wrong. Anyhow, back to your question the string you want is “[testdate]=07/11/1999”
Subject: RE: now I wonder if you mean the eleventh of July or the seventh of November
it means the eleventh of July.Thanks for your suggestion, but the problem was I used “contains” in stead of “=”. To search date type, we only can use “=” or is on. Anyway, I appreciate your response.