Hi,
I am updating a table in an Excel workbook and I am having a strange issue with the date ranges.
This following request body:
{
"values": [
[
"05/12/2021 14:48:0",
"123457",
"Smith",
"5/1/2021 14:48:0",
"Denied",
"",
""
]
]
}
Translates to the following within the sheet
12/05/2021 14:48 123457 Smith 01/05/2021 14:48 Denied
Whereas the following request body:
{
"values": [
[
"15/12/2021 14:48:0",
"123457",
"Smith",
"15/1/2021 14:48:0",
"Denied",
"",
""
]
]
}
Becomes:
15/12/2021 14:48:0 123457 Smith 15/1/2021 14:48:0 Denied
The first request has swapped the date and month around whereas the second request is displaying as I would expect.
Does anyone have any suggestions as to why this may be happening?