How to use the QUERY function to display strings by condition?

Question

Google Sheets

How to use the QUERY function to display rows where the date matches the condition today and earlier?
You need to set up a table where rows are automatically pulled from the database according to the condition <= today. So far, you have to manually enter the date in the formula every day.

=QUERY('Лента'!A:F;"select D,F where A='Задача'and C<=date'2020-07-04')

Answer 1

Substitute this for the date:

=ГОД(СЕГОДНЯ())&"-"&ДЕНЬ(СЕГОДНЯ())&"-"&МЕСЯЦ(СЕГОДНЯ())

Or this:
=ТЕКСТ(СЕГОДНЯ();".ГГГГ-ДД-ММ")
PS: I'm not 100% sure that first the day and then the month, it is quite possible that the format

YYYY-MM-DD