AnsweredAssumed Answered

Performing a find in a "date" field and getting conflicting results -

Question asked by katrina on Nov 30, 2012
Latest reply on Dec 3, 2012 by katrina

Hello,

 

I am performing a records find on a field that is a drop down calendar. When I find for week ending "12/1/2012" I am getting results for that December date and the January dates of "1/21/2012" and "01/21/2012". Same results when I perform the find for the January date - I get the December as well. This occures whether I click the date from the calendar box or just enter it in date format.

 

I have been doing these same filemaker date finds within my payroll records for years and have never received conflicting results like this. No recent changes have been made to the layout.

 

Any thoughts or suggestions as to why this may be occuring?

Thank you.

 

Katrina

Outcomes