0

Data Selection on date field

Hi,

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

Thanks,
Tommy

1 comment

Please sign in to leave a comment.