Currently, I am using the DOMO out of the box solution for converting week numbers to dates. This works great for a Sunday to Saturday week; however, a request is being made to view our week as Monday - Sunday. I have attempted DATE_ADD and WEEK variations but have been unsuccessful.
Here is my current Beast Mode:
CONCAT(DATE_ADD(DATE_FORMAT(SUBDATE(`DATE`,WEEKDAY(`DATE`)-1),'%b %d'),1),' - ',DATE_ADD(DATE_FORMAT(SUBDATE(`DATE`,WEEKDAY(`DATE`)-7),'%b %d'),1))
FYI...I did change the format to the following but that made a mess of my numbers.
CONCAT(DATE_ADD(DATE_FORMAT(SUBDATE(`DATE`,WEEKDAY(`DATE`)-2),'%b %d'),1),' - ',DATE_ADD(DATE_FORMAT(SUBDATE(`DATE`,WEEKDAY(`DATE`)-8),'%b %d'),1))
Any ideas or suggestions would be greatly appreciated.