Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
FakeJupiter
Creator
Creator

A field that checks whether date belongs to any of the specified date periods

Hi there!

Here's what I need to achieve. I'm having 2 different tables - one containing fields Name and Date and another also containing Name and Range_From and Range_To.

Essentially, I have a table showing a person's name and date showing when they have bought fuel. The other table is showing person's name and date from and date till if they have had absence. It is needed to check if they have bought fuel during their absence.

I already found a solution that does this if there is only one row of absence for each Name. However, there might be multiple rows of absence. In that case my solution only takes the first one.

How would I go about checking whether any of the dates from the first table match any of the intervals in the second table?

Maybe it is possible to achieve this with IntervalMatch()?

Thanks in advance,
Ray

Labels (3)
2 Replies
Taoufiq_Zarra

Hi,

can you share a sample data with an example

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, IntervalMatch() will solve this.

-Rob