I’m trying to generate weekly status reports from my project management app: it works, but I had to hard-code the date range for each week into a distinct view: so I have 52 views (for 2022), each of which hard-coded with a begin+end date range. I would much rather have a single view, with a filter…

Not sure I fully get what you’re trying to achieve, but it sounds like you need a formula field for week number. And then you can use this field as a filter in any views. It would be possible to use an algorithm like the one described here to get the week number: ISO week date The ISO …

Oh, and it is already possible to apply date filters like ‘Date > Last week’ for a view that should always be the latest status report.

Thanks! Yes, I can figure out how to map a week number to a date range, if necessary (ie. if I don’t/can’t use a lookup table encoded as a Database), but I can’t figure out how to prompt the user for a week number, then use the resulting date range in the filter automatically: is there an example I…

Reading your answer more carefully: I see you’re recommending a formula field: that sounds promising: but it would need to be a field of a Database, I assume: would I just create a new single-row Database, specifically to host that field? And what would be the input to that formula? I guess an act…

… so I experimented a bit and I was able to add an action button that prompts the user for a date range (I guess I could prompt for a week number and then add a formula to convert it to a date range, but I’ll worry about that later); however, my conceptual difficulty is: I want my weekly status to b…

Just to understand a bit better, can you clarify exactly what you are trying to achieve (forget about buttons, formulas etc). My guess is that you have a database of Tasks, with a date field (I assume a single date, not start and end dates?) You want a view in which the user can see a list of all …

Hi: yes, that’s exactly correct: the Task database has a [Done Date], and also a [Week End Date] (which is derived from [Done Date] as the immediately pending Friday). I want a view where the user can select any Friday, and see all the Tasks with a [Done Date] within the 7 days leading up to that F…

So I think the easiest thing to do is to define a forumla called ‘Week number’ which would be the following: RoundUp((ToDays([Week End Date] - Date(Year([Week End Date]),1,1)) + 1) / 7,0) (or something close to that depending on when you define the first week of the year to start). Then you can j…

Can’t you just use the Week End Date field as the selector in a filtered table view? [image]

Yes, you’re right: actually that’s why I created [Week End Date] - to make updating the filter as painless as possible - but it still requires knowledge of the calendar: one has to know which date to enter into the date field. I guess I should have added: I want to share this as a template and enco…

Can I create a dynamic date filter that prompts user to select a pre-determined date range?

API & Programming

Chr1sG May 1, 2023, 9:50am 16

See here

Topic		Replies	Views
January 9, 2025 / 🥳 Set any relative value in Date Filter, Batch change fields for selected entities, Improved readability in rich text fields, some new formulas Changelog	16	451	January 21, 2025
[DONE] Add "This Week" option for Date filters Ideas & Features	8	362	May 8, 2025
[DONE] Can we get a view "2 week filters" in views? Ideas & Features filter	3	92	December 18, 2024
[DONE] "This week" filter implimented? Ideas & Features	3	69	May 8, 2025
Creating a 'Current Week Calendar' Event Board with WeekDays as columns Get Help	18	392	July 16, 2026

Can I create a dynamic date filter that prompts user to select a pre-determined date range?

Related topics