0

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

null
    • Support
    • 4 yrs ago
    • Reported - view

    yearweek('Date field') will do this.

    Birger

    • Retired
    • Pete
    • 4 yrs ago
    • Reported - view

    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.

    • Sean
    • 4 yrs ago
    • Reported - view

    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

    • Design BLECHINGER
    • Michael_Blechinger
    • 3 yrs ago
    • Reported - view

    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

  • 3 yrs agoLast active
  • 4Replies
  • 1843Views