AutoIt Requires Chilkat v11.0.0+

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