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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.