PowerShell

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