Filter using relative date values ("TODAY" etc.)

We just ran into an issue where we need to trigger a Workflow on something that happened “yesterday.” Less than 1 day ago isn’t precise enough.
@karstenkoehler can you provide a link to the article where that info is found. My searches are not finding it. Is it only for filters, and not triggers?