I tried formatting a new column to contain the date but it just won't read the date when it's formatted like this : 11/24/2010. I'm not sure what you mean by the transforming between the two different numbers sentence.
On Nov 25, 1:04 am, Viz Kid <[email protected]> wrote: > 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.
