Argh, rubbish at set analysis!

[awhitfield]

I am trying to calculatte Count(distinct [Attendance ID]) where WeekStart(Today() = WeekStart(Linkdate)

Give me a clue please?

Andy

[awhitfield]

Sorry still no joy

[sunny_talwar]

A sample to look at?

[awhitfield]

Sorry no can do!

[sunny_talwar]

okay

[rubenmarin]

Hi Andy maybe is easier as:

Count(DISTINCT {<Linkdate = {">=WeekStart(Today())<=WeekEnd(Today())"}>} [Attendance ID])

To be in the same weekstart both dates have to be in the same today-week

[sunny_talwar]

Ruben - Did you miss the dollar sign expansions?

[rubenmarin]

Sure, thanks:

Count(DISTINCT {<Linkdate = {">=$(=Date(WeekStart(Today())))<=$(=Date(WeekEnd(Today())))"}>} [Attendance ID])

Also date formats can be an issue here...Maybe I'm repeating something, I didn't read all the posts carefully.

[sunny_talwar]

I tried to propose these options (at least similar)... but nothing worked... but awhitfield‌ is not willing or able to share a sample... makes it difficult to say much...