How to group by Week Number

Need help Database
1

Hi there

I have data type: Practices and it has fields:
Date
Name
DurationInMinutes

I want to populate this into Repeating Group by grouping the Week No i.e. Week 1 for 4 January 2021 - 10 January 2021) and it will be like this:

Weeks | Total DurationInMinutes
Week 1 - 2021 | 120
Week 2 - 201 | 180

But I’m not be able to do this as :groupby has no week?!?! Any other methods?

Alternatively , I could create an extra field into this date by getting the Week no and insert it.

But I prefer the firs one. Any ideas?

Thanks

1 Like
2

I am looking for something very similar - did you ever figure out a solution?

1 Like
3

I would think that creating an extra field for week number is the only solution

1 Like
4

Did anyone find a solution to this?

5

Looking for a solution to this as well