The {today} field does not seem accessible in Analytics formulas, is there another way to make custom relative date filters?

try NOW

I think it's CURRENT_DATE

CURRENT_DATE works, thanks