如何使用Regex替换Google Data Studio中日期字段中的方括号?

我正在尝试在Google Data Studio中删除日期字段周围的方括号，以便将其适当地视为正确的日期维度.

I am trying to remove square brackets around a date field in Google Data Studio so I can properly treat it as a proper date dimension.

它看起来像这样:

[2020-05-20 00:00:23]

，并且我正在使用REGEXP_REPLACE(Date, "/[\[\]']+/g", "")的RegEx，我希望它的输出看起来像这样:

and I am using the RegEx of REGEXP_REPLACE(Date, "/[\[\]']+/g", "") and I want it to look like this for the output:

2020-05-20 00:00:23

它不断给我错误结果，并且不起作用.我无法弄清楚我在做什么错，我使用了 https://www.regextester.com/确认它可以正常工作

It keeps giving me error results and will not work. I can not figure out what I am doing wrong here, I've used https://www.regextester.com/ to verify that it should work