Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with start date

My max Date is 03/03/2016.

I want to make the start of week as Sunday i.,e 02/28/2016

So I gave my expression as

=WeekStart(max(Date,0))

But it still returns start of week as 02/29/2016. Any help greatly appreciated.

1 Solution

Accepted Solutions
its_anandrjs

Did you try this

=Date(WeekStart(Today())-1)

Or

=Date(WeekStart(DateField)-1)

Regards

Anand

View solution in original post

2 Replies
its_anandrjs

Did you try this

=Date(WeekStart(Today())-1)

Or

=Date(WeekStart(DateField)-1)

Regards

Anand

johnw
Champion III
Champion III

weekstart(Date,0,-1)

The third parameter is the offset from starting on Monday.