Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to calculatte Count(distinct [Attendance ID]) where WeekStart(Today() = WeekStart(Linkdate)
Give me a clue please?
Andy
May be this
Count(DISTINCT {<Linkdate = {"=WeekStart(Linkdate) = WeekStart(Today())"}>} [Attendance ID])
or
Count(DISTINCT {<Linkdate = {"$(='>=' & WeekStart(Today()) & '<' & WeekStart(Today(), 1))"}>} [Attendance ID])
Sorry should have said I need the total for the current week
You try: Count(Distinct {$< Linkdate = {"=WeekStart(LinkDate) = WeekStart(Today())"}>} [Attendance ID])
What does the above give you?
Unfortunately the same as Count(distinct [Attendance ID])
What is the Linkdate field format?
Hi sonny,
it was Date(Floor(fk_date),'YYYY-MM-DD')AS LinkDate,
then changed it to
Date(Floor(fk_date),'YYYY/MM/DD')AS LinkDate,
But didn't make any difference 😉
Try this
Count(DISTINCT {<Linkdate = {"$(='>=' & Date(WeekStart(Today()), 'YYYY/MM/DD') & '<' & Date(WeekStart(Today(), 1), 'YYYY/MM/DD'))"}>} [Attendance ID])
With this
Date(Floor(fk_date),'YYYY/MM/DD')AS LinkDate,