user08691 Member

Comments

  • Hi there! I'm trying to group my dates by week. I'm using this formula in beast mode: CONCAT(DATE_FORMAT(SUBDATE(`Date`,WEEKDAY(`Date`)-1),'%b %d'),' - ',DATE_FORMAT(SUBDATE(`Date`,WEEKDAY(`Date`)-7),'%b %d %Y')) Problem is, when I group like this, I lose the feature of showing 0 values for dates. Please help - thank you!