Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 (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).

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 wanted format =\

What am I doing wrong? The document I'm working on is this: BENZINA

share|improve this question
    
If you use this formula, then all blank row are ignored: =QUERY(A:E;"SELECT B, COUNT(A), SUM(D) WHERE D IS NOT NULL GROUP BY B") –  Jacob Jan Tuinstra Apr 2 '13 at 19:00

1 Answer 1

up vote 2 down vote accepted

That's not possible. The QUERY documentation is primarily meant for the Google Visualization API and not the QUERY function in Google Spreadsheet. Read the following thread from the Google Product Forum: QUERY FORMAT.

What you could do instead, is to create a second column, containing the date format you want: MONTH(A2).

share|improve this answer
    
In the Documentation for the QUERY function of the Spreadsheet there's a link to the Google Visualization API and it says to follow the guidelines written there. Reference for Query Funtion. I've thought about the second column but it would have been better if I could keep just one. –  Andrea Silvestri Apr 2 '13 at 16:01
    
@AndreaSilvestri Answer remains the same. Did it help you? –  Jacob Jan Tuinstra Apr 2 '13 at 16:18
    
well.... sort of –  Andrea Silvestri Apr 3 '13 at 8:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.