3 Replies Latest reply on Feb 1, 2012 10:02 AM by philmodjunk

    Find/search dates problem

    StephenHoufe

      Title

      Find/search dates problem

      Post

      hi

      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

      thanks, stephen