It's possible that a) and b) will produce results where c) will not simply due to the fact that the date ranges are different.
If you had two records in your table with these dates:
then a) and b) will find records but c) will not.
There are records for almost each date. Isnt ... operator a date range operator.
If I had records with the follwoing dates:-
and In the find I put the range as 6/28/2013...7/3/2013... should I in theory receive the records with the follwoing dates:-
How do I make that happen?
A date range criterion will not work as expected unless the field where the criterion is specified is of type date, not text. Use Manage | Database | Fields to make sure that this is the case for your date field.
Thanks - that helped.PreferencesPreferences