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 particu...
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
    ------------------------------
    • SrinathM_R2's avatar
      SrinathM_R2
      Qrew Member
      5 years ago
      Thanks, Mark. I appreciate that.

      ------------------------------
      Srinath MR
      ------------------------------