Tuesday, April 2, 2013

yogi_WorkAround For Format Option In Select Clause Of QUERY Function


                                          Google Spreadsheet   Post  #1093
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 2, 2013
user Andrea Silvestri :(http://productforums.google.com/forum/?zx=saj65vfnlqxo#!category-topic/docs/spreadsheets/49MDx5rtzC8)

Hi everyone.

I'm trying to make this query work on my spreadsheet on chrome Win7:
=query(A1:D5;"select max(A), count(A), sum(C) group by month(A) format max(A) 'MMMM' ")

Everything is ok except for the format part.
I'd like my date to show just as a month name but it shows exactly in the standard way (dd/MM/YYYY)
What am I doing wrong?

The document I'm working on is this:

Thank you in advance!
---
I would like to point out that neither a simple query like =query(A1:D5;"select A format A 'MMMM'") displays the dates in the right formatting
-----------------------------------------------------------------------------------------------------------------------
It is a known problem that as of now (Apr-02-2013) the FORMAT option in the SELECT clause of the QUERY is non-functional.

I had a play with the problem and following is a WorkAround solution