Sunday, March 9, 2014

yogi_Query And Pull From Google Form Data Select Columns For Today Entries Meeting Additional Criteria

                                         Google Spreadsheet   Post  #1555
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-09-2014
post by Andy Chaplin (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/1eI9BjrYQDk)
Making a query based on on today's results
ve been using the query function for a while now and with the help files and the forums have managed to solve most problems, but this one is driving me crazy!

I need to do a query which just shows today's entries from a Form.  The timestamp is in Col A.  I've tried various combinations of date, dateDiff, toDate, now(), and today() but just get parse errors.  My latest attempt was this:

=QUERY(Consolidation!A2:W1000, "select B, P, Q, R, S where dateDiff(now(), A) = 0 and T = 'Krankmeldung'")

The strange thing is that when I used "> 1" in the above formula, it showed all the old results, but "= 0" throws an error.

Can anyone tell me what I am doing wrong?

Thanks for any help!
---------------------------------------------------------------------------