Does Pinot support additions or subtractions in date functions, something like:

date_trunc('week', date_parse(datestr, '%y-%m-%d')) + interval '3' day