Just cracked a unique need, where a regular LIKE meta query wasn't quite working...

Have an ACF date and time field, where we want to find other posts that happened on the same Day and Month regardless of year.

In Bricks the standard loop builder got us close using LIKE and just outputing the date as "md" format (standard PHP time formatting)...

But because of the way the dates return some months ad leading zeros, in some cases it would match numbers in the query and return posts that weren't actually on the same date.

This particular project has been really fun, lots of small little challenges doing stuff like this with this large dataset of golf aces.