I am trying to do a FTSearch where I am looking for where a field contains 101 or 100 (the full value might be 1015012)the below code is what I am trying but fails.
I have tried different variations and all failed
can someone please help???
f1IC$ = “FIELD Form Contains ““JobCosting”””
f2IC$ = "FIELD CostingMonth >= " & Format$(sDate.DateOnly,"mm/dd/yy")
f3IC$ = "FIELD CostingMonth <= " & Format$(eDate.DateOnly,"mm/dd/yy")
f4IC$ = "{@TextToNumber(@Left(JobNrMain; 3)) >= 100}"
'f5ICa$ = f1IC$ & " AND " & f2IC$ & " AND " & f3IC$ & " AND " & f4IC$
f5ICa$ = f1IC$ & " AND " & f4IC$
Set cDC = hcaDB.FTSearch(f5ICa$, 0)