Views - Date on or before "Yesterday"

Answered

Posted Aug 30, 2023

We have a custom field called "Process Date"

I want to create a view if the date is on or before "Yesterday" but it doesn't seem to have this option.

The only way i have got this kind of working is to use the within the previous 100 days, but this also adds tickets with process date as today.

Has anyone got any ideas on how i can do this?

3 comments

Date

Permanently deleted user

Zendesk LuminaryCommunity Moderator

Aug 30, 2023

Hey Zac,

Have you tried using a Automation/Trigger combination to add a tag to these tickets?

Your Automation would look like this:

Meet ALL Conditions
Ticket: Process date | is within the previous | 2 days
Ticket: Tags | Contains none of the following | process_date_overdue

Action
Ticket: Add tags | process_date_overdue

You would then add the following Trigger to remove this tag if/when the process date is changed to a future date:

Meet ALL Conditions
Ticket | is | Updated
Status | Less than | Solved
Process Date | is within the next | 100 days
Tags | Contains at least one of the following | process_date_overdue

Action
Remove tags | process_date_overdue

You can then make a View that only displays tickets with the process_date_overdue tag.

Zac Stanger

Sep 04, 2023

Would this not result in the same issue?

I want everything this today date to go into my Process | Today view. Where the process date automatically changes every 24 hours.

If a process date is set to any date before "Today" I want it to go overdue.

I want to be able to do something like blow