DateTime Math in Saved Search Criteria

I need a saved search to run for a 24 hour period that is not tied to one day.

I need to choose Sales Orders that were created between 7pm yesterday and 7pm today.

Any idea on how to do this?

Beginner Asked on October 7, 2019 in Saved Searches.
Add Comment
6 Answer(s)

Can you just use the Date Created criteria using before/after options?

RE: DateTime Math in Saved Search Criteria

Beginner Answered on October 7, 2019.

Thank you… That is what I thought…

BUT… When I set it in mine… it does not retain the selected time…

RE: DateTime Math in Saved Search Criteria

on October 7, 2019.
Add Comment

The Date Created field would be the most straight forward in my opinion but another method would be to use the System Information fields. Something like the below may also satisfy your requirement.

 

RE: DateTime Math in Saved Search Criteria

Beginner Answered on October 7, 2019.
Add Comment

When I select after yesterday in the pop-out, set the time and hit “set”…

It returns to my criteria screen without the time set… this happens for both the sales order datecreated field and the system notes: date field.  It will not save the time…

 

Beginner Answered on October 7, 2019.
Add Comment

With a record browser, I can see that there is a date time in the createddate field…

 

Beginner Answered on October 7, 2019.
Add Comment

Does anyone have any idea why I cannot set a time in the criteria of this saved search?

Beginner Answered on October 10, 2019.

Did you ever get this resolved, I am having the same issue.

on April 19, 2021.
Add Comment

@Scot and @NSinTX

When you set time in the popup, at very first you will not be able to see time, but when you Save and Run the search and then return Return to Criteria, you will see the time with date.

Rookie Answered on April 29, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor