No "Days Before" in Custom DateTime Range > Relative Date/Time

[linchangyang-sg]

Bug description

In Charts, when filtering the datetime column, it's not possible to set "From 120 days ago to one day ago" intuitively in the Custom Type. There is no "Days Before" in the End part, also no "Days After" in the Start part.

We have to use the "Advanced" type to use a negative value with DATEADD function.

Screenshots/recordings

Superset version

master / latest-dev

Python version

3.11

Node version

I don't know

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[linchangyang-sg]

In some previous version, the relative datetime range selection has identical setting for both "Start" and "End"

[dosubot]

Hi @linchangyang-sg! I'm Dosu and I'm helping the Apache Superset team.

Looking at the current implementation, the Start and End sections intentionally use different grain options — SINCE_GRAIN_OPTIONS maps all grains with the label "Before", while UNTIL_GRAIN_OPTIONS maps them with "After" [1]. This means:

• Start only shows: Days Before, Weeks Before, Months Before, etc.
• End only shows: Days After, Weeks After, Months After, etc.

This makes your use case ("from 120 days ago to 1 day ago") impossible to express using the Relative Date/Time mode for the End part, since there's no "Days Before" option there.

The screenshot you shared from a previous version suggests both directions were once available in both sections. The current code defines these as separate constant arrays with no overlap, so it would require adding "Before" options to UNTIL_GRAIN_OPTIONS (and/or "After" to SINCE_GRAIN_OPTIONS) to restore that flexibility.

As a workaround, you can use the Advanced type with something like DATEADD(DATETIME("today"), -120, day) : DATEADD(DATETIME("today"), -1, day) to express "120 days ago to 1 day ago."

To reply, just mention @dosu.

---

Docs are dead. Just use Dosu.

[linchangyang-sg]

@dosu I think a separate constant combination as x [Units] [Before/After] makes much more sense than the current implementation. Hope it could be addressed in the future version. Thanks for the reply!

[dosubot]

You're welcome, @linchangyang-sg! Your suggestion makes sense — having both "Before" and "After" available in each section (Start and End) would make the relative date picker much more flexible and intuitive for use cases like yours. This is a valid feature request that the maintainers can consider for a future release. Thanks for reporting it!

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.

[sadpandajoe]

@linchangyang-sg feel free to open up a PR for this change if you want.