How can I show a datetime timestamp formatted as 24 hour format in Google Data Studio?

Question

I have a field, timestamp, in Data Studio. The type is DateTime.

When I try to sort on timestamp, the order is not correct, and it seems to be because it is not using 24 hour format.

I have tried different uses of FORMAT_DATETIME, TODATE and PARSE_DATETIME, but can't get it to work correctly.

What I have, is the format "May 17, 2021, 2:37:55 PM".

What I want is the format "2021-05-17, 14:37:55"

user_12892553 · Answer

It can be achieved using the FORMAT_DATETIME function below, where timestamp represents the field (%F formats the Date as YYYY-MM-DD while %T formats the Time as HH:MM:SS; for a full list of the supported symbols and their respective use case, have a look through the Supported format elements for DATETIME):

FORMAT_DATETIME("%F, %T", timestamp)

Editable Google Data Studio Report (Embedded Google Sheets Data Source) and a GIF to elaborate:

FORMAT_DATETIME("%F, %T", timestamp)

Editable Google Data Studio Report (Embedded Google Sheets Data Source) and a GIF to elaborate:

How can I show a datetime timestamp formatted as 24 hour format in Google Data Studio?

1 Answers