EXCEL.TO.JSONTIME
Converts a serial date to an ISO 8601 date of following format: YYYY-MM-DDThh:mm:ss.sssZ A serial date is recognizes as a date by Streamsheets. You can get a serial date by using NOW().
Syntax
=EXCEL.TO.JSONTIME(Number)
Arguments
| Name | Type | Description |
|---|---|---|
| Number | Number | A serial number, which contains a complete date representation. |
Return
| Type | Description |
|---|---|
| String | An ISO 8601 date string. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 2012-04-23T18:25:43.511Z | The given serial number represents the 23th of April, 2012, 18:24. |