How To Filter Dates in the QUERY Function

Learn how to filter dates in the QUERY function. In this video tutorial, you'll learn how to use the "date" keyword in your WHERE clause filters, so you can use the QUERY function to return data based on dates.
📚 QUERY Function Resources:
www.benlcollin...
www.benlcollin...
🗂 QUERY Function Language Resource:
developers.goo...
🎓 QUERY Function Course - the ultimate QUERY resource:
courses.benlco...
✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
www.benlcollin...
#googlesheets #googlesheetstutorial #spreadsheet

[@Scott-sm9nm]

That was fantastic. I've used QUERY a fair amount but it seems I have to do trial and error a lot. I used to be an IBM DB2 related developer so was used to a very sophisticated and flexible SQL processor. I really appreciated you putting the querylanguage document in your description!

[@EamonnCottrell]

Awesome. Nice walkthrough, Ben. I love query and it is always a mini-puzzle figuring out dates in sheets.

[@benlcollins]

Thanks, Eamonn!

[@pancetta]

What is the role of the ampersand in the part where you’re referencing the cell. I like that it works, but i want to understand the ampersand’s role.

[@ganeshshelkar4333]

Wowww best video

[@cameron494]

so helpful!!

[@Scott-sm9nm]

Aside: a technique I've done in the past because errors referenced like 45 position within the QUERY was to make the QUERY reference the cell right above it and is where I'd store the SQL text. I would put it in a monospace font and then right above that put a ruler (IE. ----+----1----+----2----+....)

[@benlcollins]

Nice! Thanks for sharing, Scott 👍

[@RTRT-jr8jv]

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