How to filter value by date property?

Question

1C-Bitrix

trying to filter from the beginning of the month to the end

$curdate = "1.06.2016";//как пример
$lastdate = "31.06.2016";
$GLOBALS['ar2Filter'] = Array(
  "ACTIVE" => "Y", 
  //">=DATA_SOBYTIYA" => $curdate,
  "!PROPERTY" => array( 
  //">=DATA_SOBYTIYA" => $curdate,
    'DATA_SOBYTIYA' => array(
      //">=VALUE" => $curdate,'
      VALUE' => false,
      //"<=VALUE" => $lastdate)
  //"<=DATA_SOBYTIYA" => $lastdate
  ),
  //"<=DATA_SOBYTIYA" => $lastdate
);

commented out the options that I tried

Answer 1

You need to convert the date to the format stored in the database: YYYY-MM-DD.
Bitrix has some kind of monstrous crutch for this in the BD class (well, where else to format the date?), But I prefer to use the standard library of the language.