Google sheets DATEVALUE parameter cannot be parsed to date/time
Solution 1:
I believe the parse error is coming from the inclusion of the timezone. See Datetime with timezone in Google Sheets? for more information (it looks like you've already discovered that JavaScript and Apps Scripts works).