Calculating Friday to Monday as week for report

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community