How to filter for scheduled, but only for next month

Question

We are using the scheduled function a lot: when someone should be revoked access rights, when HR notifies us that someone's leaving, etc. Some of these dates are rather far in the future.

We use a filter for the dashboard to show is all upcoming and on-hold tickets. But since this list is rather long, I am trying to get a list of on-hold and scheduled, but only if the scheduled date is less than a month from now.

I am trying with

status in ("Escalated / On hold", Scheduled) AND "Planned end[<30d]"

but I don't manage to get the syntax right.

Can anyone help me?

Edit: SOLVED.

When using

Status = "Escalated / On hold" OR (Status = Scheduled AND "Planned start[Time stamp]" <= startOfDay(30)) ORDER BY key

it works. The part "[Time stamp]" is not filled by any parameter, and I should have used 'Planned start' anyway :-)

Costis Papadopoulos_c8k0qa · Answer

Hi it doesn't work for me either, any assistance would be great!

Ardjan Besse · Answer

Thanks, but sorry, it doesn't work.

When I type the filter, the 'planned end' statement autocompletes to "Planned end[Time stamp]" and I cannot find the correct syntax for this statement in the docs...

Jack Brickey_h10pa4 · Answer

Hi @Ardjan Besse , welcome to the community.

Assuming planned end only applies to scheduled status try this.

Status = "escalated / on hold" OR (Status = scheduled and "planned end" <= startofday(30))