There is no function to get the current data in the query language, so you have to construct the date yourself in javascript:
var today = new Date(); var todayString = today.getFullYear() + '-' + (today.getMonth() + 1) + '-' + today.getDate(); then in your query: var queryString = 'SELECT A, B WHERE B >= date "' + todayString + '"'; When you make a query with this string, it should produce a URL like this: https://docs.google.com/a/google.com/spreadsheets/d/1vi3Yg2mPUyTCG6eWFaTeYFSvHKwSYidZexT866xlBSE/gviz/tq?tqx=out:html&tq=SELECT+A,+B+WHERE+B+%3E%3D+date+%222014-9-1%22 On Wednesday, October 8, 2014 11:06:19 PM UTC-4, Robert Finch wrote: > > Hello. I have a spreadsheet with names and dates: > https://docs.google.com/spreadsheets/d/1vi3Yg2mPUyTCG6eWFaTeYFSvHKwSYidZexT866xlBSE/edit?usp=sharing > > I would like to query names with dates greater than or equal to the date > today. I have tried the following: > > SELECT A, B WHERE B >= "today()" > SELECT A, B WHERE B >= "&H1&" > SELECT A, B WHERE B >= "today(YYYY-MM-YY)" > > But they all return a blank table: > https://docs.google.com/spreadsheets/d/1vi3Yg2mPUyTCG6eWFaTeYFSvHKwSYidZexT866xlBSE/gviz/tq?tqx=out:html&tq=SELECT%20A%2C%20B%20WHERE%20B%20%3E%3D%20%22%26H1%26%22 > > May I please ask for any help? Thanks! > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
