Date Queries in MapObjects 2.0

Description

There is a known problem with MapObjects 2.0 and date queries that contain a "12" in the month field (MM/DD/YYYY).

Cause

Using the SearchExpression method on date values for the month of December, in any year, returns an empty Recordset. This only applies to shapefiles, VPF, CAD, and coverage data types. Date queries on SDE layers do not exhibit the problem.

There is an additional problem querying dates pre-1900.

Solution or Workaround