Google Sheets Query Dates for Dashboards - Query Formula Function

[romeowhiskey]

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

StockInfo is a Named Data Range
D is the column where my tradeDate is located.
J15 is the start date
J16 is the end date

Cut and Paste away...Good luck with your project.

[jgarygarcia]

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

[charliesmusings]

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

[camilo.wilson]

Thanks. It helped me a lot. Greetings from Chile

[rkeil]

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

[imedianew]

Thanks a lot! You are such a great person.

[marksibert]

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.

[abidsunny]

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.

[expelliarmus]

How to change data with start date and end date but it contains graphic with calender data picker. So if we choose spesific start date and end date the chart or diagram will change also same as the date we choose

[akiratellaeche]

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 <= DATE """&TEXTO(I2, "yyyy-dd-MM")&""" ORDER BY BI ASC", )""
What can I do ? Please help :(

[financekmp]

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

[angelbaladjay]

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

[ClimbHighWithAI]

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"

[RTRT-jrjv]

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?

[mritunjaysingh]

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??

[rileychumki]

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?

[MrChrisFrantz]

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.

[carpediem]

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?

[fabricekatz]

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

[josephtse]

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?