Google Sheets QUERY Date Range using SQL Format Dates Tutorial - Part 4
Вставка
- Опубліковано 11 жов 2024
- 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
www.google.com...
Website:
www.chicagocom...
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!
Big thanks! These query tutorials makes Google sheet work like exactly database. Very revolutionary. Thank you.
Your Google sheets videos are extremely helpful and very well explained, keep it up, I'm a big fan 👍
This is incredible! You sir deserve many thanks!
Thanks you so much. Love from India for your lovely tutorial.
Excelente ejemplo, lo necesitaba con urgencia, gracias!
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!
Thank you so much!!! This is great I'm your new fan!
Great content. Thank you for posting this info.
Thank you indeed for the noble work you continue to do. God bless you
Useful up to the point where you assumed I could change the format of the date field. Close, but not close enough.
感謝分享👍👍
Very clear explanation, thanks.
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.
Exactly what I needed, gracias.
Wow
Just Wow
THIS WORKS FOR ME, T H A N K Y O U - Hans
from where can i get this data sheet for practice so that i can also practice this side by side ????
I was waiting to know how to share my sheet so can help me. Please reply
Wow, I spent quite some time trying to figure out why my formula didn´t work and it was because of the format
🙏🏻
#VALUE!
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
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)?
Thanks a lot for a detailed explanation but I am not able to get it. Don't know where I am going wrong, Tried method in part 4 too. Wish you had shared your sheet with us. Wondering how to solve this issue now
parse error at line 1 column 42. There is no col 42 in my sheet
@@mangalkayande8540 What's your formula?
@@ExcelGoogleSheetsThanks so much for a quick reply. =QUERY(TRANSACTIONS!E4:F60,"SELECT E,F, WHERE E>=DATE'"& TEXT (J4,"yyyy-mm-dd") &"' and E
@@mangalkayande8540 First, remove the space here between TEXT and (
TEXT (
Let me know if you still get an error after this.
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.
I have a problem regarding this. I have added date range and I want to plot a graph based on months. For example, sale of a product happen in a different dates of different months. But I want to see the accumulated sales considering sales month and represent in graph. I aslo want that month should be selected based on my selected date range. Thanks in advance.
Watch next parts about GROUP BY and aggregate functions.
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
You can find an example here ua-cam.com/video/cH__zeKlo7Q/v-deo.html
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.
What's your formula?
Wow... This one was tough. The date format from lesson 3 doesn't work anymore. I thought that I was going nuts.
It's hard to explain, but depending on where you data comes from it will or will not work. Part 4 will definitely work.
@@ExcelGoogleSheets The method in part 4 did work. Thank you for such an awesome video series. Well done.
@@ExcelGoogleSheets Thanks a lot for a detailed explanation but I am not able to get it. Don't know where I am going wrong, Tried method in part 4 too. Wish you had shared your sheet with us.
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?
You can enter it anywhere as long as it has enough space to populate the results.
How to more filter with this function for exp. i want to know adidas total sale with date range
use AND
still header is showing on no other data...did this still same
No changes.
Found other solution...thanks btw😊
@@raymondsalamat Similar problem, buddy. Can you help me, too?
@@olduser_00 similar problem too, I already try several date formating, still didn't work
I always get the error: " Query completed with an empty output"
I am using below but it doesn't work. I can't figure out why.
="select E, F, D, H, C, A where A >= date '" & TEXT(E2,"YYYY-MM-DD") & "' and A
Did you put the double quotes “ inside the tick ‘?
@@tvandang3234 i think i forgot what I did back then. but dates should have single quotes here
HOW CAN I ADD ORDER BY OR GROUP BY WITH THIS QUERY?
ua-cam.com/play/PLv9Pf9aNgemvAMlqvHP9RhXPW98g_eo7d.html