Have a problem. Trying to query a list of stocks with upcoming earnings but I only want the stocks that have earnings over then next 7 days.
the next seven days needs to be dynamic Stocks are in column D and Earnings dates are in column AF I have tried: query(A21:aj1336,"Select D, where AF >=" &Today() &"and AF<= "& Today()+77 ")") Obvioulsy does not work. Any help would be appreciated. Thank you. On Thursday, May 1, 2014 at 9:57:24 AM UTC-4, Sergey wrote: > > Hello everyone, > > Unfortunately I don't have any updates for you guys or an estimate of when > this will be fixed, but rest assured that we are still aware of this > problem and are working towards a solution with the Docs team. We know that > this is affecting a lot of users and are working as fast as we can. I will > post to this thread, issue #1476 > <https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1476>, > > and create a new post when we have a solution or even a solid update. > > On Wed Apr 30 2014 at 6:11:03 PM, Gomez <[email protected] <javascript:>> > wrote: > >> Any idea about this? >> >> one month later and no response >> >> El sábado, 26 de abril de 2014 10:21:31 UTC-5, Sky Power and Partners >> escribió: >>> >>> Nope. Still not working till this moment. Just want to make sure it is >>> not only me. >>> >>> On Tuesday, 8 April 2014 21:40:16 UTC+8, Sergey wrote: >>> >> The new Sheets is still having issues with queries. We will update the >>>> mailing list when this is fixed. >>>> >>> >>>> - Sergey >>>> >>>> >>>> On Tue, Apr 8, 2014 at 1:46 AM, Timo Kataja wrote: >>>> >>>>> Any updates on this? I just spent hours trying to get my previous >>>>> query to work, and now I don't know if the problem is with me or with >>>>> faulty handling of dates in a query :/ >>>>> >>>> >>>>> On Monday, March 31, 2014 10:06:38 PM UTC+3, Sergey wrote: >>>>> >>>> Yes, this is now a known issue and the Docs team is looking into it. >>>>>> There are a bunch of problems with the new Sheets that they are trying >>>>>> to >>>>>> fix at the moment, so please be patient. >>>>>> >>>>> >>>>>> - Sergey >>>>>> >>>>>> >>>>>> On Mon, Mar 31, 2014 at 6:21 AM, Sky Power and Partners wrote: >>>>>> >>>>> Hello. >>>>>>> >>>>>>> I have similar problem >>>>>>> <https://docs.google.com/spreadsheets/d/11FU5aP3_9AQeegZLT1-yzhONNj1_uReHvmgEHGkiMug/edit?usp=sharing>. >>>>>>> >>>>>>> It works perfectly on the old spreadsheet, but not on the new ones.... >>>>>>> Very annoying..... >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Monday, 27 January 2014 22:44:33 UTC+8, Sergey wrote: >>>>>>> >>>>>>>> You can do this by specifying the range parameter in the URL, when >>>>>>>> you request the spreadsheet. Here is an example URL for your >>>>>>>> spreadsheet >>>>>>>> that requests the range B2:D2. I bolded the range parameter. >>>>>>>> https://docs.google.com/spreadsheet/tq?key=0AsMhU >>>>>>>> Cf4hZD6dEtuVlRydHZLQ3c4UWZLbzRYMUJiREE&*range=B2:D2*#gid=0 >>>>>>>> >>>>>>>> - Sergey >>>>>>>> >>>>>>>> >>>>>>>> On Sat, Jan 25, 2014 at 12:44 AM, 訓育組 <[email protected]> wrote: >>>>>>>> >>>>>>>>> https://docs.google.com/a/lkes.mlc.edu.tw/spreadsheet/ccc?key= >>>>>>>>> 0AsMhUCf4hZD6dEtuVlRydHZLQ3c4UWZLbzRYMUJiREE#gid=2 >>>>>>>>> I want the data between the date "B2 and D2" >>>>>>>>> How to put the command "where" in the following QUERY ？ >>>>>>>>> =QUERY('表單回應'!A:D,"select B,C,D order by B desc") >>>>>>>>> PLEASE HELP ME, THANKS~! >>>>>>>>> >>>>>>>>> TheNez於 2011年12月1日星期四UTC+8下午2時52分39秒寫道： >>>>>>>>>> >>>>>>>>>> you can use the query language to obtain that. >>>>>>>>>> >>>>>>>>>> use the playground sample to test it: http://code.google.com/api >>>>>>>>>> s/ajax/playground/?type=visualization#using_the_query_language >>>>>>>>>> >>>>>>>>>> 1. change the spreadsheet link to yours >>>>>>>>>> 2. in the setQuery function change the query to this: >>>>>>>>>> query.setQuery("SELECT C,D WHERE C >= date '2011-11-01' and C <= >>>>>>>>>> date '2011-11-30' ORDER BY C"); >>>>>>>>>> where C is the date column and D is the data column. >>>>>>>>>> pay attention to the 'date' type declaration in the query. >>>>>>>>>> >>>>>>>>>> for more details on the query language go to this link: >>>>>>>>>> http://code.google.com/apis/chart/interactive/docs/que >>>>>>>>>> rylanguage.html >>>>>>>>>> >>>>>>>>>> Good luck, >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Wed, Nov 30, 2011 at 11:07 PM, Derek <[email protected] >>>>>>>>>> > wrote: >>>>>>>>>> >>>>>>>>>>> I want to query a google spreadsheet to select some columns >>>>>>>>>>> dependant >>>>>>>>>>> on 1 date. For example, I want all records for orders shipped >>>>>>>>>>> in the >>>>>>>>>>> month of November. The ship date cell uses mm/dd/yyyy. How do I >>>>>>>>>>> write that I want all records for orders shipped between >>>>>>>>>>> 11/1/2011 and >>>>>>>>>>> 11/30/2011? >>>>>>>>>>> >>>>>>>>>>> Thanks, >>>>>>>>>>> Derek >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "Google Visualization API" group. >>>>>>>>>>> To post to this group, send email to google-visua...@ >>>>>>>>>>> googlegroups.com. >>>>>>>>>>> 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. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> 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 google-visualization-api+unsub >>>>>>>>> [email protected]. >>>>>>>>> To post to this group, send email to google-visua...@googlegroups. >>>>>>>>> com. >>>>>>>>> >>>>>>>>> Visit this group at http://groups.google.com/group >>>>>>>>> /google-visualization-api. >>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>> 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 google-visualization-api+unsub >>>>>>> [email protected]. >>>>>>> To post to this group, send email to [email protected] >>>>>>> om. >>>>>>> Visit this group at http://groups.google.com/group >>>>>>> /google-visualization-api. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> -- >>>>> 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. >>>>> >>>> -- >>> 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] >>> <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at http://groups.google.com/ >>> group/google-visualization-api. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- 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.
