Proper DateTime DataService Syntax

"items": {
            "CreatedOn": {
                "expressionType": 2,
                "parameter": {
                    "dataValueType": 8,
                    "value": "\"2022-03-03\""
                }
            }
        }

keith schmitt,

{
    "responseStatus": {
        "ErrorCode": "JsonReaderException",
        "Message": "Input string '2022-03-03' is not a valid number. Path '', line 1, position 10.",
        "Errors": []
    },
    "rowsAffected": -1,
    "nextPrcElReady": false,
    "success": false
}

This is the response when that is sent.

Tyler Rainey,

I am not sure what you are using, but in python I have to escape the \

Phase: {
                        "expressionType": 2,
                        "parameter": {
                        "dataValueType": 8,
                        "value": "\""+ date +"\""
                        }
                    }
                    }

If I look at the console when I do an update via browser it looks like this

"items":{"NextActualizationDate":{
"expressionType":2,
"parameter":{
"dataValueType":7,
"value":"\"2022-10-05T18:03:27.020\""

Hi,

It's easy to test: go to the section or detail that has the DateTime column and try adding or updating data in this column. In my case I was updating the start date and time of an activity:

We need to go to the request payload and see its source:

You can copy the content and go to any JSON beautify service online (like this) to get the readable JSON:

So as we can see the proper DateTime value is:

"StartDate": {
        "expressionType": 2,
        "parameter": {
          "dataValueType": 7,
          "value": "\"2022-10-05T21:00:00.000\""
        }
      },

So you need to specify it in the same way in your DataService request.