I’m trying to display a dynamic date that shows today minus 14 days in a Rich Text box on a dashboard. I understand Rich Text can only reference

{metric/...}

or

{label/...}

objects, but MAQL doesn’t seem to support direct date arithmetic like

DATE_ADD()

or

THIS(DAY) - 14

in a usable way. What’s the recommended approach for displaying a dynamic “today - 14 days” date?

New message text here