PowerShell 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. PowerShell

Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"

$success = $false

#  Parse Microsoft JSON Dates (AJAX Dates)
$json = New-Object Chilkat.JsonObject

$success = $json.Load("{ `"AchievementDate`":`"/Date(1540229468330-0500)/`"}")

$dt = New-Object Chilkat.CkDateTime
$success = $json.DateOf("AchievementDate",$dt)
if ($success -ne $true) {
    $("Unable to parse a date/time.")
    exit
}

#  Show the date in different formats:
$bLocal = $true
$("RFC822: " + $dt.GetAsRfc822($bLocal))
$("Timestamp: " + $dt.GetAsTimestamp($bLocal))
$("YYYY-MM-DD: " + $dt.GetAsIso8601("YYYY-MM-DD",$bLocal))

#  Get integer values for year, month, day, etc.
$dtObj = New-Object Chilkat.DtObj
$dt.ToDtObj($bLocal,$dtObj)

$("year: " + $dtObj.Year)
$("month: " + $dtObj.Month)
$("day: " + $dtObj.Day)
$("hour: " + $dtObj.Hour)
$("minute: " + $dtObj.Minute)
$("seconds: " + $dtObj.Second)

#  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