Comments
-
Using the below formula how could I switch the dates from Wednesday - Tuesday date range? CONCAT(DATE_FORMAT(SUBDATE(`DATE`, WEEKDAY(DATE_ADD(`DATE`,-1))-1),'%b %d'),' - ',DATE_FORMAT(SUBDATE(`DATE`, WEEKDAY(DATE_ADD(`DATE`,-1))-7),'%b %d'))