Time overlap detection

according to this:

https://docs.microsoft.com/en-us/off...tionary-object

the dictionary is nothing more than a glorified array. you don't need that. you can use it, but it's not necessary. you can simplify it greatly. simply loop through the rows and check the dif between the vals in the 2 columns. you can probably make use of these functions:

- datediff()
- dateadd()
- simple addition / subtraction

but yes, an array would help because obviously there is more than 1 per person, and most have overlaps.

I cannot use datediff() function because in the real world, the dates I use are Shamsi dates (example: 1399/08/18).
I think VBA Dictionary/Array is the key for this purpose. But I don't know how to implement it for my problem.

do you know how to use the info on the KB page from MS, that I gave you, to your advantage?

you have concatenated vars of diff types here:

Originally Posted by kvsrinivasamurthy

Please Login or Register  to view this content.

and in other places. that has never worked for me. furthermore, trying to concat in the ":" like you've done also has never worked for me. I get error after error. no pattern.

Originally Posted by jindon

Please Login or Register  to view this content.

Unfortunately, When I tried some different situations, I noticed that this code has some glitches. I have provided an example which cause inaccurate result:
Attachment 703323
Your code detects this situation as overlapped time interval for Alex. How can it be revised?

Originally Posted by fa2020

Thanks Jindon, this code works fine. I can run it in my PC. But in my workplace PC, it gives error in the line below:

Please Login or Register  to view this content.

It says: Automation failed
How can I solve this issue in my workplace PC?

Is it working with your other PC?

Please Login or Register  to view this content.

Originally Posted by jindon

Is it working with your other PC?

Please Login or Register  to view this content.

Thanks. It's fine.