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
5 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.
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