Bitrix how to display a getlist of records that are more than 1 day old? 1 year?

Question

1C-Bitrix

There is a table:

and a getlist:

$rsTransacts = \transaction::getList([
    'select' => [
        'USER_ID', 'DATE_CREATE', 'VALUE', 'DEBIT'
    ],
    'filter' => [
        'DATE_CREATE' => 
    ]
]);

How to correctly write a condition in DATE_CREATE to display posts for topics whose date_create is greater than 1 day from the current date? 1 year?

Answer 1

You calculate the date from which you want to count, for example, through DateTime , using the relative format .
And substitute in the condition:

'filter' => [
        '>DATE_CREATE' => "2021.11.26 00:00:00",
    ]

Here is a link to the documentation .