QS.DATETIME.PARSE

Normalizes an offset-aware RFC 3339 timestamp to UTC, preserving nanoseconds

Category: QuantSupport - Time.

QS.DATETIME.PARSE(timestamp: text) → text
Parameters:
  • timestamp (text) – Required offset-aware RFC 3339 text, e.g. 2026-01-15T16:00:00Z or 2026-01-15T17:00:00+01:00; normalized to UTC; date-only and naive timestamps are rejected

Returns:

Offset-aware RFC 3339 timestamp text normalized to UTC, preserving nanoseconds; not an Excel serial datetime.

Return Type:

text

Errors:

#VALUE! for invalid, naive, or date-only input; an explicit RFC 3339 timezone offset is required.

Formula

=QS.DATETIME.PARSE(timestamp)

Calculation

Thread-safe worksheet function.

Native Declaration

fn qs_datetime_parse (timestamp : & str) -> Result < String , XllError >

Rust source