I am trying to get data from Saturday through Monday for Tuesdays. But the below code doesn't seem to work. It is working fine for other days except Tuesday.
if(VDate = pick(weekday(today()), date(today()-3, 'YYYY-MM-DD'), date(today()-3, 'YYYY-MM-DD') or date(today()-2, 'YYYY-MM-DD') or date(today()-1, 'YYYY-MM-DD'), date(today()-1, 'YYYY-MM-DD'), date(today()-1, 'YYYY-MM-DD'), date(today()-1, 'YYYY-MM-DD')) , 1, 0) as Ind,
