Google Sheets Query Dates for Dashboards - Query Formula Function 

Here's a query FORMULA that works: =query(StockInfo, "select * where D > date '"&TEXT(DATEVALUE(J15),"yyyy-mm-dd")&"' AND D

Thank you. Very helpful. Exactly what I was looking for my budget view in google sheets. 🙌🏾

I had so much headache trying to solve how to filter using range of date. THANK YOU SO MUCH for this 👍🏼👍🏼👍🏼

Thanks a lot! You are such a great person.

Always helpful! Thanks!

Thanks. It helped me a lot. Greetings from Chile

AMAZING FORMULA, THANK YOU SO MUCH

Thank you for sharing!

Wow! Working. Thank you so much.

Thank you so much!

Dear you made my day!

Great tutorial man 👌

Wow your formula worked, thanks. How about if you need to filter also the start and end time with the dates? Can you make a video about it with start date&time and end date&time?

thanks for sharing ! I had try to use it in a report but when I select date it would reflect the data of April month in one cell while rest of the month are showing the result as per my report??

thank you , it is very useful

I have a google sheet that I use for inventory that is populated by a google form. When doing ordering I need to only see the most recent entry that was made for all of the records. I'm trying to create a query that show the most recent record entered. How do I do this please. Thank you.

thank you!it makes my work easier

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.

usefull, thansk 4 sharing. Can u open for editable ?

Hello, im trying to do the same query but with one more "and" like this but it keeps saying "error" =QUERY(basededatos,"SELECT B,C,BJ,N,K,L,AZ,BA,G,F,BK,BI WHERE BH = 'Si' AND BJ >= DATE """&TEXTO(I1,"yyyy-dd-MM")&""" AND BJ

Can i make modified on the query side? I mean once changed it will change the data sheets

How about getting the previous sales from the previous year of the selected month and year?

But i think Query formula does not work with the real-time change. for that we need to use only google script editor or do we have any other option?

My google sheets is not recognizing the data format, what should i do?

What is the function to just pull the oldest date?

Hi, how can I get K + 30 days using sheets query and K is text(not date) with YYYY-MM-DD,HH:MM:SS format?

Hello, I tried step by step but my data is still not showing. :( It's not an error just empty. I do not know what is wrong anymore regarding my formula. thank you

Nice. I have a list of different companies with different future dates, but only want the most recent date. I'm lost how to pull up just that one.

Perfect!

thank you

Does anyone know how to do this but with just one date rather than a date range?

How can I fix this? I have a large file with over 6000 rows and need to extract specific rows with specific words, couldn’t find anything else, will appreciate any help! "Cannot parse query string for function QUERY parameter 2: COLUMN_ONLY_ONCE: AD"

Oh happy day!!!!

Incredibly helpful! Although I'm stumped on how to add more dropdowns. So not only the 2 dates but additional dropdowns IE Opponent and Win/Loss. Any help?

What will the formula be when getting the query from another sheet? I can't get it to work. And does date format matter? E.g. US date format vs EU date format? Thanks.

But, this formula does not work when the dates are in a row. I tried but everytime it shows, "Formula parse error".

It is hard to see in small screen, like smart phones

good

ang pogi

Thanks Bro....please also make Video on Query by Color Range

IT IS NOT WORKING IN MY SHEET

10Q Bro

what if I only want to use 'month' only? without the date and year I tried to use the same formula but it failed

Share plz formula

Thanks for your video. I tried for hours to get this results and when I found your page, it was done in 5 minutes !

Screen to far

Thanks! This totally worked Here's the formula --> DATE """&TEXT(A1, "yyyy-MM-dd")&"""

Thank you, this really helped me on my report. I use this formula DATE ' "&TEXT(A1,"yyyy-mm-dd")&" '