Assigning a session to a week

[Archer]

Hi there,

I am building a time tracking app and need to have particular data filtered by a Monday-Sunday week.

For example, todays time entry “6hr” should be in this week 14th-20th. Then in a report I should be able to see this time entry under this week.

does anybody know the best way to have this?

Thanks,
Archer

[Flawless]

Hey there @Archer

This one is kinda tough as the days that belong to each week shift every year. I’ve gotten good at figuring out how to calculate and display based on month/day/year but not by the number of the week.

In this thread, I mention how to display info based on month/day/year, if this helps:

Track how many days a user checks in each month

First, add 2 (or 3) new number parameters to the “Check ins collection” and label them “Month” and “Year” (optionally add the 3rd for Day). On the home screen, add 2 more input components and label them “Month” and “Year” (and the optional 3rd input for “Day”). Make the inputs transparent and/or hide them behind a rectangle. Set the default value for all 3 to “Date & Time > Current Time” and then change the date format to the specified format for each field. Month = Month Number, Year = Year …

At a minimum, you’d be able to do reports based on the day and/or month and/or year.

So thinking about how you could implement the days, you could do something similar where you put an input component and set the default value to “Start of today” with a date format of “Day of the week” (i.e., Monday) but I’m not quite sure how we’d know which week of the year it is.

Hopefully, this can get you started on it.