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:
https://docs.google.com/
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
No comments:
Post a Comment