How do I "do a search" on a date, excluding the time?

[Minty]

I have a thing named Social Post that stores social media images. It has a date field called Scheduled Date/Time which stores values like Dec 1, 2020 10:57 am. When the date and time is correct, I will send those images off to the correct social media platform.

And now I want to use the Calendar Tool plugin to generate a repeating group calendar. It will show a calendar with thumbnails of all the upcoming social media posts.

Each square of the calendar is a repeating group cell containing a “date”, with the time component defaulting to 12am. For example: Dec 1, 2020 12:00 am, Dec 2, 2020 12:00 am, Dec 3, 2020 12:00 am, etc.

Now for each date on the calendar I want to show the a thumbnail of the social media images that are scheduled for that day.

The problem is that when I “do a search for” a Social Post with a matching calendar cell date (Dec 1, 2020 12:00 am) it does not exactly match the Scheduled date/time (Dec 1, 2020 10:57 am) because the time component of the date field does not match exactly (12:00am vs 10:57 am).

I only need the dates to match. So how do I “do a search” but exclude the time component of a date field?

You can see a screenshot here of the search I am trying to do. It won’t let me format the Scheduled Date/Time before comparing it to the parent cell date:

[Minty]

Ok I solved it by adding two time constrains using > and < instead of just =. It seems to have done the trick. Screenshot below. If anyone else knows a better solution please advise.

[bcart0v]

The way you do it is exactly the way that I do it more or less.

I’m not aware of any other way that works. I’ve been told that if you change the hours/minutes/seconds to 0, it ignores everything but the date but that did not work for me.

[casheets123]

Setting hours/minutes/seconds to 0, should do it. But I did notice recently that this no longer worked. No sure what gives, maybe it’s obsolete or the planets doesn’t align.

Anyway, if you want to find all entries for Today e.g. set it to current date/time:rounded down to day.

See if that gives you what you want. @Minty