cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate start date and last date for current week

Former Member
0 Kudos

Dear All.

i want to calculate the start of the current week as well as the last date of the current week, our week start from Saturday and ends of Friday i.e. Saturday is the first day of the week and Friday is the last day of the week.

How can i acheive this in universe Designer?.

Please help...

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

the formulas in webi will be as follows

for startdate

=RelativeDate(LastDayOfWeek(CurrentDate());-8)

for enddate:

=RelativeDate(LastDayOfWeek(CurrentDate());-2)

Regards,

Ranganath