Hello!
I have a card that is filtered to the previous week. In the title of the card, or in a summary number within the card, I'm trying to show the start date of the data. Something like:
"Card Title | Week of 9/9/2024"
And the date portion of that title would be automated. Every week when the card details change, that title would update with last weeks date for Monday. I couldn't get that to work with the 'Smart Text' Options within the cart title options. So I've also tried to use a beast mode and just use the Summary Number options. But I couldn't get the beast mode to work either. I've tried this (and a few other variations), but no luck yet:
Attempt #1:
DATE_ADD(CURRENT_DATE(), INTERVAL -7 - WEEKDAY(CURRENT_DATE()) DAY)
Attempt #2:
DATE_SUB(CURRENT_DATE(), INTERVAL (WEEKDAY(CURRENT_DATE()) + 7) DAY)
Attempt #2 was closer, but returning the wrong date consistently. Any help here would be great!