Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
What's the target for your task?