Hi All, I have a Google Spreadsheet with a timeofday data type column, like this:
B 16:00:00 18:45:00 17:22:00 I am pulling the data in via a Google Visualization API query and I am wondering how do I construct my SELECT filter to get all rows where the time in column A is equal or greater than right now? Here is the relevant code segment: *var today= new Date(); var time=today.getTime(); InitQueryString="select * where B>="+time;* I am getting zero rows returned, but no errors. PS. f I just query on column A, it contains the day number like 0 for Sunday, to get me everything which is today, that works fine, so it is not my syntax for the actual query. This works fine: *var today= new Date();var thisDay=today.getDay();* *InitQueryString="select * where A="+thisDay;* I also verified that I have the format for column B right, when I just pull all data, the column is of type: <https://lh4.googleusercontent.com/-XyFq7hiKTO8/UxoNohfnYRI/AAAAAAAAAFw/BM5GdDdkwYI/s1600/result.jpg> Thank you in advance, Sincerely, Gabor -- 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.
