EXCEL2JSONTIME

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 Eclipse Streamsheets. You can get a serial date by using NOW().

Syntax

=EXCEL2JSONTIME(Number)

Arguments

Name	Description
Number	A serial number, which contains a complete date representation.

Return

An ISO 8601 date string.

Examples

Formula	Result	Comment
=EXCEL2JSONTIME(15453.767864710648)	2012-04-23T18:25:43.511Z	The given serial number represents the 23th of April, 2012, 18:24.