Filtering with dates in the QUERY function - Ben Collins (Ben Collins)
Working with dates in the Query function in Google Sheets can be tricky. This tutorial shows you the correct syntax and examples.

This year I have been creating a monthly summary of posts and updates associated with all things GSuite. It occurred to me after nine months that I should really be storing all the links in some sort of database. My question is how to automate the process of turning that into a monthly post.
I have been getting on the GAS and am thinking that QUERY might be a part of my solution. I am therefore trying to get everything working in Sheets first. I have followed your guide to QUERY, even adding in two dynamic selectors (is that what they are called?) that I got from your work on VLOOKUPS. My question is filtering by dates. I have followed your instructions for filtering between two dates:

 =QUERY(Data!$A$1:$H$136,”select C, B where B > date ‘”&TEXT(A1,”yyyy-mm-dd”)&”‘ and B <= date ‘”&TEXT(B1,”yyyy-mm-dd”)&”‘”,1)

But fear that I maybe limited as I have recorded my dates using DD-MM-YYYY. Sheets recognises this as a date as a formatted the cells as ‘DATES’. My spreadsheet settings have also been changed to ‘Australia’. I am wondering if you have any thoughts or suggestions on this? Here is a link to my sheet.

4 Ways that Google Might be Hurting Education by Bernard Bull
false

This is such an interesting post Bernard. In regards to the ‘commercialisation of educators’, I am a Google Certified Innovator and enjoyed my experience at Google. However, it was the opportunity to work with other passionate educators which was the boon, not the focus on tools.

I was a Google Educator before they changed the program, but my credentials have since lapsed. I could justify completing the credentials as it is a core part of my current work. However, I have concerns about ticking a box. I prefer to use my time to develop my own capacity myself, documented in my monthly newsletter. I think that Rafranz Davis captures some of the issues too.

In regards to the influence of Google, I am more concerned about the influence of GAFA, FANGS or whatever acronym you choose to use. I am happy to support teachers where they are at. I have written about Apple, Adobe and Microsoft. I have also written about open software and managing my own domain. In regards to disclosure, I would like to think that I am transparent, but I guess I could always do better.

Pickles and Shoe Tying by Alan Levine
false

I love this comment Alan:

What I think is worth writing about are things in your day that nibble at your attention. That make you pause, ever so briefly.

I think sometimes I forget this. Interestingly, Kin Lane shared something similar lately to:

It would KILL ME to not be able to tell stories. I need storytelling to do what I do. To work through ideas. It is how I learn from others.

You have both reinvigorated me to stop worrying and just get back to sharing and storytelling.

css.php