Using Variables in Beast Mode
Hi all, I'm trying to write a Beast Mode and it would be much easier if I could declare a variable to make my code a bit simpler. I would want to do something like this: CASE WHEN `Date of Death` is NULL THEN FLOOR(DATEDIFF(CURRENT_DATE(), `Date of Birth`)/365) ELSE FLOOR(DATEDIFF(`Date of Death`, `Date of Birth`)/365) END…