First Day of the Week

system · November 17, 2009, 12:17am

We have a function in WEBI called ‘Last Day of the Week’. How can we get ‘First Day of the Week’ assuming SAT day is the first day of the week.

Here is the variable for last day:

=LastDayOfWeek([Case Dt (truncated)])

Developer_Designer (BOB member since 2009-08-09)

system · November 17, 2009, 4:47am

Try something like this.

=RelativeDate(LastDayOfWeek([Case Dt (truncated)]);-7)

Jansi (BOB member since 2008-05-12)