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

Question

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.

Answer 1

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.

• Docs on PARSE_DATETIME.
• Format elements list.