Find/search dates problem
FM has stopped me searching for dates -
I will search for (for example) 1.12.11
I get "find criteria is not valid" message
and when I do a re-find I discover FM is looking for this: * 1 2012 * 12 2012 * * 2011
I have been using FM for 20 years and have had no problems searching using this database & this field before, but for some reason it has suddenly stopped me searching dates ( text fields continue to search ok - it just seems to be dates).
I have tried using different date formats to search - inc copying the exising data in the field and also using the claendar option
any suggestions what may've happened