JSONTIME.TO.EXCEL
Converts an ISO 8601 date string to a serial number. A serial number is recognized as a date by Streamsheets. You can get a serial number by using NOW().
Syntax
=JSONTIME.TO.EXCEL(text)
Arguments
| Name | Type | Description |
|---|---|---|
| text | String | An ISO 8601 date string of following format: YYYY-MM-DDThh:mm:ss.sssZ. Note: minutes, seconds and milliseconds are optional and single digits are allowed. |
Return
| Type | Description |
|---|---|
| Number | A serial number representing the specified date string. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 15453.767864710648 | The given ISO date as serial date. |