I need to get the start date of a week. My week need to start from Sun to Sat. And when I tried using WeekStart function of QlikView, if the first day of the month starts from the middle of the week, I get the weekstart date from previous month.
How can I start my WeekStart dates from first day of the month?
For October 2014, I get the weekstart output as
I want my output as :
10/01/2014 --------> Always my first week of the month should be first of that month.