The following is the Before Integration script that prompts the user for the cutoff dates and set the Global variables. This script also checks to verify that valid dates were entered and that the ending date is equal to or greater than the beginning date.
The following is the Before Query script that must be used in the Header query of the integration. In this case the date field being filtered on in this query is named "TrxDate":
The datatype for the date field your query setup must be set to Date. Also, because this script uses the AdditionalCriteria property, it will only work with Text File or Simple ODBC queries. Advanced ODBC queries in Integration Manager cannot use the AdditionalCriteria property