Skip to Content
Jul 15, 2020 at 05:08 PM

Friday to Friday calculation


I have requirement where i have to get weekly (friday to thursday) data from a normal date range.

DB is SQL, and bo 4.2 sp6.

i got this working for sunday (since its lastdayofweek)

=FormatDate(RelativeDate(LastDayOfWeek([Report Date]);-7);"MM/dd")

Report Date is a Date Field.

i have tried Mod, dayname, daynumber ... but each time running into Datatype issues.

Any help would be greatly appreciated.