API Query Help

13 views

Skip to first unread message

Mike

unread,

Dec 18, 2017, 4:34:46 PM12/18/17

to Google Visualization API

Hi, I am trying to query certain data based on the month listed in the date in Column D. Could someone please advise what I need to change about this the below query...

=query('Form Responses 1'!A1:D, " select A,B,C,D where A is not null and D is month('Column Header', dec) format C '$#,00.00' ",1)