Set Analysis with unique event dates between two times

[Anonymous]

Hi all,

I am trying to count events that happen between two timestamps and also they happen in distinct dates. So if there are two events on the same date, only counts for 1. The dates in the data model come with time associated but that doesn't matter. Also, the reference timestamps are in another table.

Here is my attempt:

Count ( {<Table1.EventID={"=Table1.EventTime>=Table2.TimeStamp1<=Table2.Timestamp2"}>}Table1.EventID)

This only gives me zero values so clearly I am not writing the syntax right for the interval. How that could be done?

And then, when I do the interval, how do I work with dates and not the timestamp completely?

And last part, how can I just count the ones that happen in distinct dates?

Thank you very much for any help. Unfortunately, I cannot upload data from this project.

Cheers,

Fabiola