Comments
-
I believe I figured it out… case when Date >= '08/01/2023' and Team Member in ('Name') then (case when Team in ('Team A') then 'Team B' else Team end) else Team end
-
Thanks Mark. I do want all data from the left table and to only provide exact matching data from the right table so the left join is correct in my situation. I will create a copy and test.
-
I was able to find a solution that correctly identifies the week date range starting Monday and ending Sunday. If there are any other suggestions/solutions please let me know. CONCAT(DATE_FORMAT(SUBDATE(`DATE`, WEEKDAY(DATE_ADD(`DATE`,-1))-1),'%b %d'),' - ',DATE_FORMAT(SUBDATE(`DATE`, WEEKDAY(DATE_ADD(`DATE`,-1))-7),'%b…