Remote dataset does not parse date fields

Get Help
1

I have this json:

{
    "data": [
        {
            "id": 1,
            "date": "2018-10-10 13:11:21",
            "title": "Test 1"
        },
        {
            "id": 2,
            "date": "2018-10-11 03:04:41",
            "title": "Test 2"
        },
        {
            "id": 3,
            "date": "2018-10-12 06:51:21",
            "title": "Test 3"
        }
    ]
}

And I set date column like this:

image
image875×664 12.8 KB

But when I try to test data I get mydate field set to null:

{
    "entries": [
        {
            "data": [
                {
                    "id": 1,
                    "date": "2018-10-10 13:16:08",
                    "title": "Test 1"
                },
                {
                    "id": 2,
                    "date": "11/10/2018 03:09:28",
                    "title": "Test 2"
                },
                {
                    "id": 3,
                    "date": "2018-10-12 06:56:08",
                    "title": "Test 3"
                }
            ]
        }
    ],
    "number": 1,
    "processed": [
        [
            {
                "myid": 1,
                "mydate": null,
                "mytitle": "Test 1"
            },
            {
                "myid": 2,
                "mydate": null,
                "mytitle": "Test 2"
            },
            {
                "myid": 3,
                "mydate": null,
                "mytitle": "Test 3"
            }
        ]
    ],
    "messages": [
        "Processing 1 results into 3 potential columns",
        "Processing Result with Data Root data",
        "DataRoot is an array",
        "Processing 0",
        "Processing 1",
        "Processing 2",
        "Consolidating entries",
        "There are 3 entries in total"
    ]
}

I tried to change the format of the dates but I get always null

2

I find the problem:
in DataSetFactory.php I change the line

case 3:
     // This expects an ISO date
     $result[$column->heading] = $this->getSanitizer()->getDate($value[1]);

with

case 3:
    // This expects an ISO date
    $result[$column->heading] = $this->getSanitizer()->getDate($value[0],null,$entry);

And then everything works as expected