(Excel) How to Parse a TimeStamp (such as 2016-11-11T14:32:17.0908971Z)

Timestamps are frequently used in REST API responses. This example demonstrates how to parse a timestamp string to get at the date/time components in the local timezone or in the GMT/UTC timezone.

Download Excel Class Modules Chilkat Excel Class Modules

' Let's say we have a timestamp string such as 2016-11-11T14:32:17.0908971Z

strTimestamp = "2016-11-11T14:32:17.0908971Z"

Dim dateTime As Chilkat.CkDateTime
Set dateTime = Chilkat.NewCkDateTime
Dim success As Boolean
success = dateTime.SetFromTimestamp(strTimestamp)

' Get a DtObj in the local timezone.

bLocalTimezone = True

Set dt = dateTime.GetDtObj(bLocalTimezone)

' Get the individual date/time components
Debug.Print "-- Local Time --"
Debug.Print "Year: "; dt.Year
Debug.Print "Month: "; dt.Month
Debug.Print "Day: "; dt.Day
Debug.Print "Hour: "; dt.Hour
Debug.Print "Minutes: "; dt.Minute
Debug.Print "Seconds: "; dt.Second

' Get a DtObj in the GMT/UTC timezone.
bLocalTimezone = False
Set dt = dateTime.GetDtObj(bLocalTimezone)

' Get the individual date/time components
Debug.Print "-- UTC Time --"
Debug.Print "Year: "; dt.Year
Debug.Print "Month: "; dt.Month
Debug.Print "Day: "; dt.Day
Debug.Print "Hour: "; dt.Hour
Debug.Print "Minutes: "; dt.Minute
Debug.Print "Seconds: "; dt.Second