Query posts with date as custom field

Hi,
in theory it’s possible. Which is the format of the date stored in the custom field?

You can use the panel “Getting posts” > “Custom fields query”, for example see this screenshot:

As you can see, I have:
– custom field key A1 = date
– custom field value = 2018-05-25 00:00
– operator = > (greater than)
– type = DATETIME

This query returns posts that have a custom field key date where its value is greater than 2018-05-25 00:00.

Try and let me know.

Unfortunately that’s not possible. If the posts you want to get are unpublished, you could query posts with “Scheduled” status and with custom field date (or any other custom field).

Great idea, @pavelevap! I should add more filters like this.

I added a filter before returning $meta_query.

I just pushed this commit to GitHub and now you can use a function like this:

function pis_edit_meta_query( $args ) {
	$args[0]['value'] = date( 'Y-m-d H:i' );

	return $args;
}
add_filter( 'pis_meta_query', 'pis_edit_meta_query' );

This function will change the value with the current date and time, regardless of what has been entered in the widget.

The commit is in the develop branch, so you should manually download the update or simply change the line in your plugin installation.

If you confirm me that all works as intended, I will add this in the master branch.

About the ordering, I just used:
– “Getting posts” > “Order posts by” > “Meta value”
– “Getting posts” > “The order will be” > “Descending” (or “Ascending”)
and the posts are ordered by this meta value.

Please, let me know.

• This reply was modified 5 years, 5 months ago by Aldo Latino.

I’ve added a new filter exactly here and it’s named pis_custom_field_value.

The filter lets you change the date and the time before they are displayed.

In the functions.php file of my test theme, I tested this function:

function pis_make_datetime_human_readable( $datetime ) {
	// Get the date and the time formats as they are defined in the WordPress dashboard.
	$date_format = get_option( 'date_format' ) . ' (' . get_option( 'time_format' ) . ')';
	// Convert $datetime to UNIX timestamp, as requested by date_i18n() later.
	$datetime = strtotime( esc_html( $datetime ) );
	// Convert UNIX timestamp according to my date and time formats.
	$datetime = date_i18n( $date_format, $datetime );

	return $datetime;
}
add_filter( 'pis_custom_field_value', 'pis_make_datetime_human_readable' );

It echoes this output:

4th March 2021 (13:50)

as you requested. 🙂

Let me know, please.

@pavelevap you’re very welcome!

Thank you for your posts! 🙂