QS.DATETIME.DATE¶
Returns the UTC calendar date of an offset-aware timestamp, not its market business date
Category: QuantSupport - Time.
- QS.DATETIME.DATE(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:
ISO date text for the timestamp’s UTC calendar day; this is not a market business or valuation date.
- Return Type:
text
- Errors:
#VALUE! for invalid, naive, or date-only input; an explicit RFC 3339 timezone offset is required.
Formula¶
=QS.DATETIME.DATE(timestamp)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_datetime_date (timestamp : & str) -> Result < String , XllError >