It seems that you are right - the timestamp column you have is counting days since 1/1/1900 which is not what toDate expects. In order to solve it, you can simply format that column in the spreadsheet to be Date (by pressing the "123" button and choosing "Date"). Otherwise, you will need to transform between the two different numbers yourself (switching between days and milliseconds and the offset of 1970 instead of 1900).
Best, Viz Kid On Thu, Nov 25, 2010 at 6:58 AM, Deliman96 <[email protected]> wrote: > I am trying all of this stuff in various ways and it's just working > for me. I'm really unsure of what the problem is. it will show the > column headers but it just wont show any of the rows unless i place > that date in the 12345.6789 notation. > > On Nov 24, 1:05 am, Viz Kid <[email protected]> wrote: > > This is clear now. > > > > Luckily, you can perform what you need. > > First, the complete documentation pages of the query language can be > found > > here: > http://code.google.com/apis/visualization/documentation/querylanguage... > > > > When you want to translate a date in string format like '2010-11-23' into > a > > real date you can simply use the keyword 'date' (for example: 'where date > > '2010-11-23' < A'). If the column A is not of type date but rather a > > datetime, you can either construct a datetime in the query using the > > datetime keyword or convert column A to a date using toDate(A) in the > query > > instead of A. Also, you have the now() scalar function so you can use > > toDate(now()) to get the current date. > > > > The scalar functions documentation (in the same page): > http://code.google.com/apis/visualization/documentation/querylanguage... > > > > Hope this helps, > > Viz Kid > > > > > > > > > > > > > > > > On Wed, Nov 24, 2010 at 5:32 AM, Deliman96 <[email protected]> wrote: > > > Sorry about the link. It was just an example of the query where it > > > says "select B,C,D,E". I didn't intend for it to actually link. > > > > > The following link is the page where I learned about what I am trying > > > to do. > > > > >http://blog.ouseful.info/2009/05/18/using-google-spreadsheets-as-a-da. > .. > > > > > These two links are the spreadsheet and query. > > > > >https://spreadsheets.google.com/ccc?key=tYK02LkiX1h0uQCFb8i-uKw&hl=en. > .. > > > > >https://spreadsheets.google.com/tq?tqx=out:html&tq=select%20A,B%20whe. > .. > > > > > What I want to do is have a link where it will do a query that is > > > something like "where A contains today", so that everyday the link > > > will query that day. So the same link will pull all the rows where > > > column A contains "11/23/2010" on 11/23/2010 and on the next day > > > (11/24/2010) all the rows where A contains "11/24/2010". Sorry, this > > > feels rather difficult to describe clearly. There are few problems I > > > am having. The first is that it doesn't seem to take "today" as a > > > valid query. If there is something that it WILL take, that would be > > > best. If I have to actually do it by each individual day, it would be > > > nice to be able to query it using the actual formatted way: > > > "11/24/2010". But the time stamp is actually a decimal number that > > > represents the day: "40505.861400463". It will only take the decimal > > > number in the url. > > > > > I think that's about as descript and clear as I can get. If you have > > > any more questions let me know. > > > > > What I would like to do is have something > > > On Nov 23, 3:14 am, Viz Kid <[email protected]> wrote: > > > > Hi > > > > > > I'm not sure what you meant (and I cannot see the spreadsheet you > linked > > > > to). > > > > Please try to explain in more details and possibly provide > > > > an accessible example spreadsheet. > > > > > > Best, > > > > Viz Kid > > > > > > On Fri, Nov 19, 2010 at 6:11 AM, Deliman96 <[email protected]> > wrote: > > > > > Hello, > > > > > > > I am trying to query a google spreadsheet using the url like so: > > > > > > > > http://spreadsheets.google.com/tq?tqx=out:html&tq=%20select%20B,C,D,E. > > > .. > > > > > > > What I would like to do is have a code that will always query it > > > > > according to "today" ( what ever day it may be at the time) right > now > > > > > I tried to use the "where A contains '40496'" but that is only for > a > > > > > single day. I would like it to be dynamic. > > > > > > > Thanks > > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > Groups > > > > > "Google Visualization API" group. > > > > > To post to this group, send email to > > > > > [email protected]. > > > > > To unsubscribe from this group, send email to > > > > > [email protected]<google-visualization-api%[email protected]><google-visualization- > api%[email protected] <api%[email protected]> > ><google-visualization- > > > api%[email protected]<api%[email protected]>< > api%[email protected]<api%[email protected]> > >> > > > > > . > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/google-visualization-api?hl=en. > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "Google Visualization API" group. > > > To post to this group, send email to > > > [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<google-visualization-api%[email protected]><google-visualization- > api%[email protected] <api%[email protected]>> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/google-visualization-api?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
