- Last Active
I tried this and it looks like it works. (DATEDIFF(CURDATE(),'12/31/2016') / DATEDIFF('12/31/2016','10/1/2016'))*-1 It's not complete, but you can definitely use a CASE WHEN argument to move this value dynamically. Try it without the CASE WHEN first, then you can add clauses later. Not 100% sure how to avoid hard coding…
Just curious, are you running a Beastmode, or using Workbench (either a transform or query)? Try updating the last formatting clause in your Concat string as '%m/%d/%Y' vs '%m%d%Y' (notice the backslashes). Hope this helps!