AutoIt

Parse a Microsoft JSON Date (MS AJAX Date)

See more JSON Examples

Demonstrates how to parse a Microsoft JSON Date, also known as an MSAJAX date. AutoIt

Local $bSuccess = False

; Parse Microsoft JSON Dates (AJAX Dates)
$oJson = ObjCreate("Chilkat.JsonObject")

$bSuccess = $oJson.Load("{ ""AchievementDate"":""/Date(1540229468330-0500)/""}")

$oDt = ObjCreate("Chilkat.CkDateTime")
$bSuccess = $oJson.DateOf("AchievementDate",$oDt)
If ($bSuccess <> True) Then
    ConsoleWrite("Unable to parse a date/time." & @CRLF)
    Exit
EndIf

; Show the date in different formats:
Local $bLocal = True
ConsoleWrite("RFC822: " & $oDt.GetAsRfc822($bLocal) & @CRLF)
ConsoleWrite("Timestamp: " & $oDt.GetAsTimestamp($bLocal) & @CRLF)
ConsoleWrite("YYYY-MM-DD: " & $oDt.GetAsIso8601("YYYY-MM-DD",$bLocal) & @CRLF)

; Get integer values for year, month, day, etc.
$oDtObj = ObjCreate("Chilkat.DtObj")
$oDt.ToDtObj $bLocal,$oDtObj

ConsoleWrite("year: " & $oDtObj.Year & @CRLF)
ConsoleWrite("month: " & $oDtObj.Month & @CRLF)
ConsoleWrite("day: " & $oDtObj.Day & @CRLF)
ConsoleWrite("hour: " & $oDtObj.Hour & @CRLF)
ConsoleWrite("minute: " & $oDtObj.Minute & @CRLF)
ConsoleWrite("seconds: " & $oDtObj.Second & @CRLF)

; Sample output:
; RFC822: Mon, 22 Oct 2018 17:31:08 -0500
; Timestamp: 2018-10-22T17:31:08-05:00
; YYYY-MM-DD: 2018-10-22
; year: 2018
; month: 10
; day: 22
; hour: 17
; minute: 31
; seconds: 8