AnsweredAssumed Answered

Issue with date feild when in find mode.

Question asked by NonProfitEducationUser on May 21, 2014
Latest reply on May 23, 2014 by TSGal

Summary

Issue with date feild when in find mode.

Product

FileMaker Pro

Version

12

Operating system version

Windows

Description of the issue

When I do a search on a calculated date feild, it only gives me partial results. Please see the following post for all the steps I have taken to try to resolve this issue:

http://forums.filemaker.com/posts/ae297968a5

Steps to reproduce the problem

Please see discussion board post link above.

Expected result

To be able to do a range date search based on a few months of the year (for monthly and quarterly reports).

Actual result

I can do some date searches, but not other searches. When I try to search for 11/*/2013, I get results from the 11th day of a month. (Have looked at reformatting all of the dates in many ways to try to resolve it already).

Exact text of any error message(s) that appear

No error message, or "no records found matching that critera" (when there should be results).

Workaround

Please see the linked discussion. No work arounds found, but some searches will give me results, and others won't. (But I can't run the searches I neeD).

Outcomes