I am loading a table, call it SelectionDates, that has four dates in it. I want the next table that loads to load with a Where statement that looks at the dates from the SelectionDates table and filters the data.
Thanks Peter. Still having problems. I need a statement with will look at the first date that the second date and give all records that equal to or between the two dates. Like "Where TransactionDate >= 1/1/2009 and TransactionDate <=12/31/2009" But the dates are from the first table loaded.
Perhaps use peek() to find your values and assign them to variables, then reference the variables when doing the second load? Or alternatively use the variables to generate all TransactionDates between the two dates, then load where exists(TransactionDate).
Have tried peek, put into a variable (vstartdate) but the script then says cant find field "vstartdate". I have tried puting the peek statement in the where statement also. The script runs but no records are returned.
