Select a Field with max Date Between two other dates

[#1]

Hi Folks,

Please help me, I'm getting mad.

I have two tables...

Moviment table - which has the hospital section  and the date/Hour that the pacient was moved.. and

Collect table - which has the kind of vital signs, and the date/hour that it was collected...

I need to report where was the pacient when each vital sign was collected.

I thought to take the max Date of Moviment table between the previous Collect Date and the actual Collect date. But I don't even know how to do it.

Anyone has an Idea?

[MK_QSL]

I think IntervalMatch function at script will help you on this.

Can you provide few lines of sample data for both tables.. (around 5 to 6 lines with two different patients)

Also provide the output you needed