Advanced Search Help

Hello! I am looking to search tickets that were last updated anytime before today.

Ex. Any ticket with a last updated date/time before Midnight should be pulled. However, when I am doing “LastUpdated < Today” It is pulling tickets from today and before when it should only be pulling from yesterday. I have tried “LastUpdated < Yesterday” And “LastUpdated <= Yesterday” but no success.

Please help!

You can add the time to your query, so “LastUpdated < ‘today 00:00:00’” would give you anything updated before the current calendar day.

This worked!! Thank you so much!