ac-column-custom-field-stored_date_format.php

<?php
/**
 * The filter allows you to specify the stored date format for a custom field.
 * This is necessary when you are using the `date` smart filters and not seeing correct results.
 */

/**
 * @param string                 $date_format 'Y-m-d H:i:s', 'Y-m-d' or 'U'. Default is 'Y-m-d H:i:s'
 * @param ACP\Column\CustomField $column
 *
 * @return string
 */
function acp_custom_field_stored_date_format( $date_format, ACP\Column\CustomField $column ) {

	// Specifify the date format for a specific custom field
	// $date_format = 'Y-m-d';

	return $date_format;
}

add_filter( 'acp/custom_field/stored_date_format', 'acp_custom_field_stored_date_format', 10, 2 );

/**
 * Set the date format for a specific key to a timestamp `U'
 *
 * @param string                 $date_format 'Y-m-d H:i:s', 'Y-m-d' or 'U'. Default is 'Y-m-d H:i:s'
 * @param ACP\Column\CustomField $column
 *
 * @return string
 */
function acp_set_custom_field_stored_date_format( $date_format, ACP\Column\CustomField $column ) {

	if ( 'my_date_meta_key' === $column->get_meta_key() ) {

		// Set the date format to 'U' Unix timestamp
		$date_format = 'U';
	}

	return $date_format;
}

add_filter( 'acp/custom_field/stored_date_format', 'acp_set_custom_field_stored_date_format', 10, 2 );