One Date Selection Source, for multiple data sets

[#1]

Hi,

How do i create one set of dates for filtering purposes that will filter both data sources.

I have one set of records that are hourly records of money made. (Datetime)

The second are automated messages that get sent out, also time stamped.

How do I get both sets of data to filter when I select dates in a List box?

[Gysbert_Wassenaar]

See this tutorial. The tutorial selects in only one date field, but you can simply add the same kind of Select in Field actions for another field to make the selections in that other field too.

[#3]

Why not just set them up to be a common key

table1:

qualify *;

unqualify date;

load

date,

sales,

employee

from sql select blah blah blah table1

table2:

qualify *;

unqualify date;

load

date,

sales,

employee

from sql select blah blah blah table2

[#4]

Gives me errors?

[#5]

I think that the code before your first line above as not got a terminator ";"

change

Collections:

qualify *;

to be

;

collections:

qualify *;

Also the field you are unqualifying needs to exist as one of your load fields so

unqualify CollectionEndTime;  would be fine

but because you have not done a load on CollectionEndDate then

unqualify CollectionEndDate; will fail.