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.