Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
BTW - there is a good Help article also in Sense on intervalmatch function use in the load script.