Functions: Today() Intnx - align to start/end of week, this week or previous - may need tweaking depending on your requirements Find start/end date of intervals date_start = intnx('week', today(), -1, 's')-1; date_end = date_start + 7; if date_start < date < date_end;
... View more