QUERY function | Dealing with date

In this tip, we are going to explore:
QUERY function | Dealing with date
All explanations are simple and to the point.

#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets

Feel free to make your copy of this spreadsheet template:

Useful Link:
Google Workspace Tutorial:

Ben Collins (Google Developer Expert & Data Analytics Instructor)

Google Sheets training:

The Playlist link:

Follow us on Pinterest:

In this table, we have the dates to pay the invoices
If the Invoice payment date, is the current date, it will appear in this table.
To achieve that, we use this formula:
=QUERY(A2:B4,"SELECT * WHERE B = date '"&TEXT(TODAY(),"yyyy-mm-dd")&"'",1)
To add the date to our query, we start with the word date and single quotation marks
Then we add "&&"
The date should be in this format.
The TODAY returns the current date.
And the TEXT to format the date.