AnsweredAssumed Answered

Incorrect Date Comparison - 12/7/2009 >= 1/15/2010 evaluates to true

Question asked by apitire on Jan 12, 2010
Latest reply on Jan 12, 2010 by philmodjunk

Summary

Incorrect Date Comparison - 12/7/2009 >= 1/15/2010 evaluates to true

Description of the issue

Issue: FileMaker is incorrectly comparing dates. 12/7/2009 >= 1/15/2010 is evaluating to 1 (true) Screenshot avilable. Steps to Reproduce: Open Data ViewerEnter 12/7/2009 >= 1/15/2010 as the calulationClick Evaluate Now Result:1 Expected Result:0 Workaround:  12/7/2009 >= Date ( 1; 15; 2010) correctly evaluates to false Environment:FileMaker 10v3Windows 

Outcomes