Dear all,
FTserach does not filter according to view index( date index ) . Date field is first column in the view.
sql will be
numDocs =DisputeView.FTSearch(“(FIELD Group = " & congroup &”) & (FIELD Group = " & IndividualG &“) & (FIELD PriNameSelection = " & Dispute &”) & (FIELD CurrDate > " & FromDate & " | FIELD CurrDate = " & FromDate & ") & (FIELD CurrDate < " & ToDate & " | FIELD CurrDate = " & ToDate & “)” , 0)
Thanking in advance