Forum Discussion

SrinathM_R2's avatar
SrinathM_R2
Qrew Member
5 years ago

Calculating Friday to Monday as week for report

Hi All, 

I wanted to generate reports on particular table where I want the data to be on weekly basis but the week should start on Friday and end on Thursday. Since I wanted it only for one particular report in one table I don't want to reset my week start day to Friday for the entire app. What could be the alternative for this?

Thanks.

------------------------------
Srinath MR
------------------------------
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    if you want the report to group by a different field, you can create a new date field called [Friday Week] 

    The formula would be FirstDayofWeek([My Date field]) - Days(2)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • SrinathM_R2's avatar
      SrinathM_R2
      Qrew Member
      5 years ago
      Hi Mark, 

      Do you mean [Date Created] - Days(2)? Also, I am using this in a summary report if that makes a difference compared to charts.

      ------------------------------
      Srinath MR
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        ToDate([Date Created]) - Days(2)

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------