How to make a request in Google Docs?

Question

Google

help, there is a column A with dates. On another sheet, you need to draw the columns and rows in them so that there are only those with a date in column A = today.
=QUERY('ARMOR'!A:O; select A,E,D,H,G,K where A = .......????

Answer 1

You need to enter the value of the current date in the query.
For example,

=QUERY('БРОНИ'!A:O; "select A,E,D,H,G,K where toDate(A) = date '" & TEXT(NOW(),"YYYY-MM-DD") & "'"; 1)

I note that if you use the now () operator of the query language, then it returns the result for a month more
=QUERY(,"select toDate(now())")
Therefore, it is preferable to form a date from a string.
ZY: please change the post tag to spreadsheets