Beast Mode: Nested Case Statement Help
Hey, I'm trying to select week id base on the current day and I wrote below case statement. But I'm getting error in here. Can someone help? (CASE WHEN week_id <= ( CASE WHEN CURRENT_DATE() BETWEEN '2024-02-10' AND '2024-02-16' THEN 1 WHEN CURRENT_DATE() BETWEEN '2024-02-17' AND '2024-02-23' THEN 2 WHEN CURRENT_DATE()…
