I am very new to Jet and i'm trying to use Jet Data Manager Server to pull information from two data sources (one is MS SQL, one is MySQL) into a staging database.
The fact tables in each data source are very large, so i want to add data selection rules to the tables so that only records from this month will be included.
With the MS SQL data source, the field i am filtering on is type datetime, if i use date is greater than or equal 11/01/2015, this works and i only get records from this month.
However on the MySQL data source, the field i need to filter on is type timestamp e.g. 2015-11-19 13:20:00 i can't find the right data selection rule to only include records from this month
Data Selection on date field