I have a database with a field called “played” that is set as the “Date and Time” value.
When I try populating it with a standard timestamp, it does not recognize it and claims that it’s text. (“Cell value type is Text. Change to Date and Time.”)
When I click “Change to Date and Time” though it recognizes the values and sets it correctly.
How can I get it to update by itself?
This is the JSON I am sending:
{"author":"alan",
"title":"久遠の河",
"dj":"djname",
"type":1,
"id":"4Oc0tBsc91s",
"playID":480854,
"played":"2018-04-19T22:04:25.000Z",
"plays":6,
"op":-1,
"alt":null}
Edit: I solved it with:
json.played = new Date(json.played);
Though it does not seem like a good solution overall.