Learning and Sharing
  • Home
  • Blog
  • Linux
  • macOS
  • Virtualization
    • VMware
    • VirtualBox
  • Windows
    • Windows 11
    • Windows 10
    • Windows Server
  • Series
    • Symantec
    • Intune
    • Microsoft Azure
    • Powershell
    • VirtualBox
    • VMware
    • PowerShell Learning
    • Microsoft Graph
  • More
    • Auto Installation
    • AEC Installation
  • Contact
No Result
View All Result
  • Home
  • Blog
  • Linux
  • macOS
  • Virtualization
    • VMware
    • VirtualBox
  • Windows
    • Windows 11
    • Windows 10
    • Windows Server
  • Series
    • Symantec
    • Intune
    • Microsoft Azure
    • Powershell
    • VirtualBox
    • VMware
    • PowerShell Learning
    • Microsoft Graph
  • More
    • Auto Installation
    • AEC Installation
  • Contact
No Result
View All Result
No Result
View All Result

Converting DateTime Obtained from Microsoft Graph Call to PowerShell Date and Time Format

October 21, 2023
in Blog, Microsoft Graph, Powershell
0
ADVERTISEMENT

Table of Contents

Convert a Text String to a Correct Date Time Format

We have a PowerShell script where we perform the call to get the renewal date of a Microsoft 365 subscription with Microsoft Graph API.

$subId = '27689fc1-239d-491f-b11d-06f0d3ab7819'
$uri = "https://graph.microsoft.com/beta/directory/subscriptions/$subId"
$RenewalDate = (Invoke-RestMethod -Method GET -Headers $headers -Uri $uri).nextLifecycleDateTime
$RenewalDate
PS C:\> $RenewalDate
2024-08-13T00:00:00Z

The output format like the following “2024-08-13T00:00:00Z”. This is not recognized as a valid DateTime format when we’re trying to use it with a PowerShell operator.

PS C:\> ($RenewalDate – $((Get-Date).Date)).Days
Cannot convert value “2024-08-13T00:00:00Z” to type “System.Int32”. Error: “Input string was not in a correct format.”
At line:1 char:19
+ ($RenewalDate – $((Get-Date).Date)).Days
+ ~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvalidCastFromStringToInteger

For example, we got the following error when counting the days to renew from today.

fdXAZtbbY6eQOTR2ZubkSn7VGp4E1PfQelbDmNszQxqfZpLWE7WQkcVDW3TL

When we check it with Get-Member we can see its type is string.

PS C:\> $RenewalDate
2024-08-13T00:00:00Z
PS C:\> $RenewalDate | Get-Member

   TypeName: System.String

The type of a date time object in PowerShell should be System.DateTime.

PS C:\> $((Get-Date).Date) | Get-Member

   TypeName: System.DateTime

To dealing with this, we need to convert the System.String to System.DateTime.

[Datetime]::ParseExact($RenewalDate, 'yyyy-MM-ddTHH:mm:ssZ', $null)

As you can see, now the renewal date shows as normally.

hZWc0QbYpz7FpdZr5QY5wFCKkQ2M1rf3mJWpwNnWCllsDYm9ilyBbZMh0U6l

Then we can use it as a PowerShell object with PowerShell operators.

ZzjsakkrQl0uEj6oVS2kUnwL1ASaeY309wl4kacKgkIlBbOCILRm0DBo1csB

Not a reader? Watch this related video tutorial:

5/5 - (1 vote)
Previous Post

How to Get Microsoft 365 License Expiration Dates using Graph Api

Next Post

How to Fix PowerShell GUI Freezes when Running

Related Posts

Running Hyper-V and VMware Workstation on The Same Machine

August 15, 2024

How to Uninstall All Autodesk Products At Once Silently

July 29, 2024
Ftr5

How to Uninstall the Autodesk Genuine Service on Windows

July 29, 2024
Ftr19

How to Fix Windows Cannot Read the ProductKey From the Unattend Answer File in VirtualBox

July 26, 2024
Ftr25

How to Update Windows Terminal in Windows 10/11

July 26, 2024

How to Disable The Beep Sound in WSL Terminal on Windows

July 26, 2024

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • How To Turn On uBlock Origin Extension in Chrome (2025)
  • Images Hidden Due To Mature Content Settings In CivitAI
  • Azure OpenAI vs Azure AI Hub, How to Choose the Right One for Your Needs

Categories

Stay in Touch

Discord Server

Join the Discord server with the site members for all questions and discussions.

Telegram Community

Jump in Telegram server. Ask questions and discuss everything with the site members.

Youtube Channel

Watch more videos, learning and sharing with Leo ❤❤❤. Sharing to be better.

Newsletter

Join the movement and receive our weekly Tech related newsletter. It’s Free.

General

Microsoft Windows

Microsoft Office

VMware

VirtualBox

Technology

PowerShell

Microsoft 365

Microsoft Teams

Email Servers

Copyright 2025 © All rights Reserved. Design by Leo with ❤

No Result
View All Result
  • Home
  • Linux
  • Intune
  • macOS
  • VMware
  • VirtualBox
  • Powershell
  • Windows 10
  • Windows 11
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Office
  • Active Directory

No Result
View All Result
  • Home
  • Linux
  • Intune
  • macOS
  • VMware
  • VirtualBox
  • Powershell
  • Windows 10
  • Windows 11
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Office
  • Active Directory