AnsweredAssumed Answered

Strange date query problem

Question asked by mz5005 on Jan 28, 2017
Latest reply on Jan 28, 2017 by philmodjunk

I search often on date ranges (eg >2017/01/15 - my date settings yyyy/mm/dd). Always works fine.

However, now I have a file where the queries constantly give the right records plus a set of "out of range" records.

I have restarted FMP and even restarted my computer, but still the same problem.

When I sort the records on the dates, the sorting is done properly and I see nothing strange.

 

The file is made up of several smaller files from different sources (and therefore maybe different date formats), can that maybe cause something?

And if so, how can I see if that would the problem? Again, I see n0thing strange and sorting works properly.

 

I checked the forum on earlier reported bugs - only few old ones (am on FMP15).

 

Anybody an idea? Thanks in advance!

Outcomes