Profile: Ido Angel

Problem: I would like to calculate an age in years based on a given birth year.

Solution: It's not possible to calculate an age with only a year. You must have a year, month, and day to perform an accurate calculation. I have created a custom shortcode for this purpose, you can adapt for your needs.

Relevant Documentation:
https://toolset.com/forums/topic/custom-date/#post-571557

Problem:
How to add a filter to show only future events from the Events Calendar plugin in a View?

Solution:
The start date is stored as in the field "_EventStartDateUTC" but it is not stored in the timestamp format used by Types date fields, and to filter by this field you will need to use the wpv_filter_query hook.

Here is an example of such code (the View ID would need editing):

/**
 * Filter event query to show future events
 */
function tssupp_filter_event_query($view_args, $view_settings, $view_id) {
 
  if ( in_array( $view_id, array( 123 ) ) ) { // Edit View ID(s)
 
    if (!isset($view_args['meta_query'])) {
 
      $view_args['meta_query'] = array();
    }
 
    $meta_query = array(
 
      'key' => '_EventStartDateUTC',
      'value' => date("Y-m-d H:i:s"),
      'type' => 'DATETIME',
      'compare' => '>',
    );
 
    $view_args['meta_query'][] = $meta_query;
 
  }
    return $view_args;
}
add_filter('wpv_filter_query', 'tssupp_filter_event_query', 101, 3);

The thread also includes an example of code that would be used to filter between a range of dates.

Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query