Group by week
Is there a function that I can use on date field to group by week with the week starting either on Sunday or Monday and going 7 days
4 replies
-
yearweek('Date field')will do this.Birger
-
I find that the formula you suggest only works for Monday-Friday. I am tabulating how many miles I walk per day (multiple walks per day) and I walk 7 days a week. So, the totals come up short. I am finding it difficult to locate a list of formulas/functions that can be used. Is there an index of codes with examples? I am coming from using Panorama by ProVue and just looking for some simple database solutions for home use.
-
Hello, I find it works Monday-Sunday. I don't know it the date format makes a difference. Here is a link to the Scripting Functions...
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
-
is there script the week like its possible for the day, and now, it should be possible for this week, which automatically takes this current week.
Content aside
- 5 yrs agoLast active
- 4Replies
- 1874Views