Displaying a repeating group of things created on a specific day

Hello, I currently have a drop down with a few dates as seen below.

Untitasdasdssled

The dates are just a “grouped by” of the list I have, grouped by the day they were created so if multiple items were created on the same day, you would only see that day once in the dropdown instead of several times.

In that image i am trying to sort by october 2nd, so in a repeating group I am trying to get everything created that day no matter what hour to display. I have tried to use the range function, but I can not seem to figure out how to do this. Whenever I try to sort the created date by any range I get no results.

Hi @Drahgoone, you need to use two search parameters for the date.

One that specifies the Created Date is equal to or greater than the dropdown’s date change hours to 0 change minutes to 0 change seconds to 0. That will set the minimum time to 12:00:00 am of the selected day.

A second one that specifies the Created Date is less than the dropdown’s date change hours to 0 change minutes to 0 change seconds to 0 + (days): 1. That will set the maximum time to 11:59:59 of the selected day.

image

4 Likes