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

What the heck? Why is this not an option? I need to be able to automate a reminder that lets me know when a close date is drawing near. This is stupid simple… not sure why it’s not a thing yet.