If I read the documentation correctly, I can't do a compound query using the same field. This means I have to figure out how to make op=bw work for date fields. Does anyone have an alternative approach?
I found the same problem when switching over to FMS/FMSA12. I was using a single date to find records and this too returned an error. My workaround was to insert an operator (eq) before the date, thus eliminating the bw operator which appears by default.
Incidentally, I had the same problem with searches involving number fields. A search for 1234 returned 1234, 12345, 123456 etc. Again, the inclusion of the eq operator fixed this. I posted this query on a number of forums/fora, but never recieved a reply. I was hoping that maybe someone at Filemaker might respond. No-one did. But then, what on earth was I thinking...
Hope this helps