Google Sheets QUERY Date Range using SQL Format Dates Tutorial - Part 4

Video tutorial series about QUERY function in Google Sheets.

In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results within a specific date range using SQL date formatting and the date keyword.

Google Sheets

Website:

[travelingtrex]

You just saved me at least 2 hours on manipulating date in the query function. You saved me from banging my head against the wall. Thank you very much!

[rotrose]

Big thanks! These query tutorials makes Google sheet work like exactly database. Very revolutionary. Thank you.

[thomasnolleau]

Your Google sheets videos are extremely helpful and very well explained, keep it up, I'm a big fan 👍

[dharmendrayadav-cnfi]

Thanks you so much. Love from India for your lovely tutorial.

[jobhunt]

This is incredible! You sir deserve many thanks!

[jenniferwright]

Thank you, I knew you should be able to do this but it was driving me nuts trying to figure out how to reference a start and end date!

[stephenkirk]

Useful up to the point where you assumed I could change the format of the date field. Close, but not close enough.

[dannfish]

Great content. Thank you for posting this info.

[rawihcito]

Excelente ejemplo, lo necesitaba con urgencia, gracias!

[dadtrepreneur]

Great tutorial videos. I curious to konw, does the Select funtion have a limit of how many colums we can add? I'm trying to to do it with 50 columns and it's giving me a #value error message. Need help.

[tvutesi]

Thank you so much!!! This is great I'm your new fan!

[Rbits]

Thank you indeed for the noble work you continue to do. God bless you

[mangalkayande]

I was waiting to know how to share my sheet so can help me. Please reply

[kenmsmith]

Is there a way to filter a Google sheet to only show the last 7 days of data (using the date values in a date column)?

[hoangthan]

I have a sheet 1 which is submitted by GG form in which column A is time stamp, on Sheet 2 I want to query sheet 1 base on date (which is column A of sheet 1) larger than B1 of sheet 2 so here it is: =query('sheet 1'A2:Z; "select * where A >"&B1;0) and the result is N/A while it is certainly not true. Any help would be great. Thanks in advance.

[yashodhanraut]

Sir,
I am importing data by using query function and after importing, I want to sort date, but when I try to sort date, I don't allow, I automatically get to same position

[workkinhoman]

I would like to know why you could enter the query formula in the cell that is not at the top left cell of result list? how to do that?

[julioauy]

Wow, I spent quite some time trying to figure out why my formula didn´t work and it was because of the format

[dawudfreedmedia]

How would you do it if you wanted just variables in the formula. E.g. you put the start and end dates...than you convert these using the TEXT function in two other cells and then want to reference these two properly formatted cells in the formula? I tried to replace the text() in the formula (to make it easier to read and/edit) with the cell reference and it won't work. Is there something special you need to do or is it not possible?

=QUERY(Sheet2!A2:G85, "select * Where C <= Date '"&j2&"' Order by C", )

where j2 =TEXT(J1, "yyyy-mm-dd")

[stephentackett]

I wish you would paste your code. I can't get this to work and have copied exactly each step. I can get the date to change dynamically in the cell but when I paste it into the main code with the & and all that it doesn't work. I have copied exactly.