How to fetch records from entity base on only Day and month?

Question

How to fetch records from entity base on only Day and month

Like In DOB need to return those user which has current day and month.

E.g:

$query = \Drupal::entityQuery('user');
$query->condition('status', 1);
$query->condition('field_dob', date('m-d'));
$entity_ids = $query->execute();

In anyone have idea how to do this?

Answer 1

Here we are doing a LIKE query as the question stated that it wants to fetch record on basis of current month and day only not a year .

 $query= \Drupal::entityQuery('user')
     ->condition('field_dob','%'.date('m-d').'%', 'LIKE')
     ->execute()