How to select leads by time (from 06:00 pm to 09:00 am) for each day in Bitrix24?

Question

Bitrix24

How to select leads by time (from 18:00 to 09:00) for each day?

That is, I need to filter out leads that come during non-working hours (from 18 pm of the current day to 09 am of the next day)

. day, and I need for a period (week, month, year)

Answer 1

the current date can be obtained in php
and used in the filter:

"filter": {
    ">DATE_CREATE": "2019-08-08T18:00:00+03:00",
    "<DATE_CREATE": "2019-08-09T09:00:00+03:00"
  },

it will be something like this

$date = new DateTime();
$date1 = new DateTime('+1 day');

"filter": {
    ">DATE_CREATE": $date->format('Y-m-d')."T18:00:00+03:00",
    "<DATE_CREATE": $date1->format('Y-m-d')."T09:00:00+03:00"
  },

Answer 2

Looking for reports? If there is no access to a standard field with the necessary data, then you need to create your own in crm and write in it as a robot or BP after the fact.
You can then use this field to filter on kanban, list, or reports.