to_date converts Excel serial numbers such as 45212.5 to ISO 8601 dates, to_serial turns ISO dates into serial numbers. Works on up to 1000 values at once, in the 1900 or the 1904 date system, and handles the Excel 1900 leap year bug. A value that cannot be converted is reported on its own row and never stops the others.
Updated
Parameters
Name
Type
Required
Description
direction
one of: to_date, to_serial
yes
Request body
Name
Type
Required
Description
values
array of string
yes
Serial numbers such as 45212.5, or ISO 8601 dates such as 2023-10-13 or 2023-10-13T12:00:00
date_system
one of: 1900, 1904
no
1900 is the default of Excel for Windows and current Mac Excel, 1904 is for old Mac workbooks (default "1900")
Example request
A request body that works, as JSON.
{"values":["45212.5","45318"]}
Response
The fields inside data of a successful response.
Name
Type
Required
Description
results
array of ExcelSerialResult
yes
One result per input value, in order
count
integer
yes
Number of values received
failed_count
integer
yes
Number of values that could not be converted
Example response
A real answer from the operation, as JSON. The fields in the table above are inside data.