How I convert "2020-09-23T15:08:03.259Z" into time format in data studio?

Viewed 270

I'm facing trouble to convert "2020-09-23T15:08:03.259Z" into basic time format in google data studio. Can anyone please help me to figure out this.

Thanks.

1 Answers

Try PARSE_DATETIME in a custom field:

PARSE_DATETIME("%Y-%m-%dT%H:%M:%E*SZ", DateTimeText), where DateTimeText is your original field with the date time string.

Related