I have 3 Tables listed below and their respective linking.
1. Sales
2. Project
3. IVR
Sales and Project linked with ID, Sales and IVR linked with ID & Date & CLI_No.
I have Created_Time in Sales Table and Start_Time, End_Time in IVR Table. I want to check in which Interval of Start_Time and End_time does my Create_Time lies. Also, What if there is One to Many Relation in Sales<=> IVR table.
I have already implemented IntervalMatch() but unable to get the desired Result.Kindly assist.
Would be best if you could upload a small sample QVW that can be reloaded (so either use some INLINE tables with sample data or some Excel tables attached), and also attach your requested result (e.g. as another excel table).
