Relative filter on the date field

1

How does the relative filter on the date field works in 8base?

2

Can you please let us know what problem you’re trying to solve? I’m not sure by the question. Thanks!