B
B
brakazyaber2021-02-26 17:51:43
Google Sheets
brakazyaber, 2021-02-26 17:51:43

How to change date format when querying QUERY in Google Sheet?

The task is to display a column with the name of the month in Google sheets. Simple formatting is not suitable, because the lines are added through a google form. In this case, the set format flies / overwrites. For the same reason, you cannot immediately write formulas in cells. I found a solution for displaying the date through a QUERY query
=QUERY(A:J;"select B";1), where column B is the date of the format "03/10/2021" and the title in the first line
. As a result, you need to get the date of the "MMM" format, i.e. "mar."
I know that you can use the format function in the request, but according to the available examples and descriptions, I still don’t understand how to use it.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question