Parsing date information returns #NAME?

Ask the Community
#1

When parsing JSON which includes a date as YYYY-MM-DD, an invalid syntax error (#NAME?) is returned.

Example:
A1: {"date":"2017-10-31"}
A2: =PARSE(A1,"date") --> #NAME?

Is there a way to cast the type that is returned? Displaying the date as a string would be totally fine in this case.

Thanks
Marc

#2

@marc I’m checking this, thanks for reporting.

It doesn’t seem to be a problem of the date.

Did you paste the JSON on the cell yourself?

#3

Hi @humberto,
I got the JSON via GET() and parsed it then in another cell.
I will send you the API call and the path I tried to parse.

#4

I am on it! Will have news soon. Thanks @marc.

#5

Hello @marc
This problem should be corrected. Do you mind checking?

#6

Hi @humberto,
problem solved, thanks a lot!