Site Visits during a Time Period?

[#1]

Hi!

I have two database tables:  one that holds visits to websites and another which contains a schedule of classes.   I need to join the two tables so I can track the websites visited during a class period.  

The website visits table has a time field for when the student visited the site.  The Schedule table has a start and end time for each class period.  

Any ideas on how I can accomplish this? 

[kuczynska]

Hi,

You should probably consider using intervalmatch() to associate times from website tables and start/end times of class.

Have a look here - this pdf explains very well on how this could be done in QV; don't see a reason why this wouldn't work in Sense.

intevalMatch.pdf

BTW - there is a good Help article also in Sense on intervalmatch function use in the load script.