JSONTIME2EXCEL

Converts an ISO 8601 date string to a serial number. A serial number is recognized as a date by Eclipse Streamsheets. You can get a serial number by using NOW().

Syntax

=JSONTIME2EXCEL(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

A serial number representing the specified date string.

Examples

Formula	Result	Comment
=JSONTIME2EXCEL(2012-04-23T18:25:43.511Z)	15453.767864710648	The given ISO date as serial date.