Hi,
I query data from a database (using Google query on G.spreadsheet) where columns are formatted as dates.
However, once the query is done, 3 columns out of 6 (where each column is filled by dates) are formatted as Text and not date and the cells are not responsive to any format request I do.
Is there something I should be aware of between query and formatting? I have tried to solve this issue the whole day but I do not find a way to get around.
Cheers
I query data from a database (using Google query on G.spreadsheet) where columns are formatted as dates.
However, once the query is done, 3 columns out of 6 (where each column is filled by dates) are formatted as Text and not date and the cells are not responsive to any format request I do.
Is there something I should be aware of between query and formatting? I have tried to solve this issue the whole day but I do not find a way to get around.
Cheers
