I think that the best possibility is to find a way to make the column be formatted as a date in the spreadsheet itself. You should be able to choose whatever format you prefer.
On Fri, Nov 26, 2010 at 5:29 AM, Deliman96 <[email protected]> wrote: > 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]> > > > > > ><google-visualization- > > > > > api%[email protected]<api%[email protected]> > <api%[email protected]<api%[email protected]> > >< > > > 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]> > ><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.
