This Pro tutorial shows how to configure ACF and Meta Box to query posts in Bricks by custom field(s) of the type Date/Date Time Picker when using ACF or Date/Datetime when using Meta Box.
Update on 16 May 2023: Display posts only from today and in the future – Show only the posts whose date-type custom field’s value is today or in the future
Update on 24 Jan 2023: This tutorial has also been tested with a Date type of field created using Pods and is confirmed to work.
Let’s take an example of a testimonial custom post type with banner_start and banner_end custom fields of Date or type.
The process is the same regardless of which custom fields plugin is used.
The objective is to pull all the testimonials for which banner_start is equal to earlier/less than/before now AND banner_end is equal to or later/greater than/after now i.e., basically show the banners which are relevant at the current moment in time.
So our meta query should be like this:
banner_start <= current_time && banner_end >= current_time
ACF
Display and Return Formats do not matter and can be left at their default or set to any.
Meta Box
Set the Save format for your fields to Y-m-d for Date fields or Y-m-d H:i:s for Datetime fields.
Set up the Meta Query like this for your Posts element or the Query Loop element like this:
Date
Meta value to check against:
{echo:wp_date(Y-m-d)}
Update: Alternatively, Meta value can be set like this:
{current_date:Y-m-d}
Display posts from today and in the future
Example meta query to show only the posts whose date-type custom field’s value is today or in the future:
where project_launch is the name/ID of your custom field.
Date Time Picker or Datetime
Meta value to check against:
{echo:wp_date(Y-m-d H:i:s)}
—
Note that only the Posts/CPT items for which the fields are populated will be pulled. If there are any posts for which both fields are empty, they will not be output.
References
https://www.advancedcustomfields.com/resources/date-time-picker/#query-posts-within-date-range
https://docs.metabox.io/fields/datetime/#saving-dates-in-another-format
https://academy.bricksbuilder.io/article/dynamic-data/
https://wpdevdesign.com/date-and-time-in-wordpress-dev-notes/