note: test automated emails after deploying this. removed stragglers using old today() manager method, hopefully caught all these now since it will break the automated emails if so.