Rounding dates?

[sam1]

Hello,
I have a date select field that I am using to filter a collection and I am wondering if there is a way to have it when the date is selected it is rounded to the day? When I set it currently it will have a time as well “2024-01-07T20:44:43.051Z”. So then when I go to filter my collection I will only get results that have a date after the time stamp rather then after the start of the day.

I have found a solution where I set the seconds hour and minutes to 0 but I’m still curious if there’s a way to have it so the date and time picker sets the time to the start of the day.

[the_sms]

By adding the Date plugin…extension you gain the ability todo date formats as well as it adds a bunch of date functions as seen in the included screenshot. You might find what you are looking for in this plugin.

[sam1]

I found that by adding a workflow on the trigger of the date & time picker you can then round it using the set minutes set hours, ect to round it to the day.