Rukovoditel Support Forum

support wrote: ↑31 Jul 2022, 15:53 Try this

Code: Select all

FROM_UNIXTIME(e.field_826, '%Y-%m-%d') = '[filter_by_date]'

'[filter_by_date]' - with quotes.

zeljkoK wrote: ↑28 Oct 2022, 11:50 Dear all,

I had a problem with a date filter where the date delimiter (-) was used as a math operator (The filter subtracted the month number from the year).

I solved it in the following way:
WHERE from_unixtime(e.field_1621, '%Y-%m') = "[filter_by_date]" (double quotes)

However, the problem remains that the datepicker control still does not pick up the defined language, but the expressions are only in English regardless of the selected language (Currently Croatian!).

datepicker.png

$date = '[filter_by_date]';
$date = explode("-", $date);

switch ($date[1]) {
  case "01":
    $month = "Ocak";
    break;
  case "02":
    $month = "Şubat";
    break;
  case "03":
    $month = "Mart";
    break;
  case "04":
    $month = "Nisan";
    break;
  case "05":
    $month = "Mayıs";
    break;
  case "06":
    $month = "Haziran";
    break;
  case "07":
    $month = "Temmuz";
    break;
  case "08":
    $month = "Ağustos";
    break;
  case "09":
    $month = "Eylül";
    break;
  case "10":
    $month = "Ekim";
    break;
  case "11":
    $month = "Kasım";
    break;
  case "12":
    $month = "Aralık";
    break;
}

$date = $month . " " . $date[0];
$output_value = $date;

zeljkoK wrote: ↑31 Oct 2022, 15:21 Dear Sergey,

excelent work. Calendar picker is now OK.
However, the output phrase ($output_value = (date('F Y', strtotime('[filter_by_date]')));) is still in English.
output.png