How to convert string dates in PowerShell?

Question

I'm working with a SharePoint list and it's common date/time format is 2020-01-06T08:09:00.0000000Z. I have source date that I'm writing to that list that's in another format, i.e. 11.07.2012 09:40.

How can I convert that string into the format that the SharePoint list expects?

Closest I've come is:

[datetime]$dateToConvert = "11.07.2012 09:40" Get-Date -Date $dateToConvert -Format FileDateTimeUniversal

which outputs 20121107T0840000000Z but that's missing the dashes.

Any ideas?

Try with -Format o

Mathias R. Jessen
– Mathias R. Jessen

2020-01-06 09:41:35 +00:00
Commented Jan 6, 2020 at 9:41 — Mathias R. Jessen
– Mathias R. Jessen, Commented Jan 6, 2020 at 9:41

Alexis Mathieu · Accepted Answer · 2020-01-06 09:52:47Z

2

You can try this: $dateToConvert.ToUniversalTime().ToString("o")

ToUniversalTime() to get the "Z" at the end (instead of the UTC offset)
ToString("o") to get a string that complies with ISO 8601

answered Jan 6, 2020 at 9:52

Alexis Mathieu

6925 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

MokiTa Over a year ago

This doesn't work with PS 5.1, is this a new feature i PS 6.0?

Mark Harwood Over a year ago

@MokiTa Might be your .Net that is out of date. Here is the Microsoft documentation for ToUniversalTime() Link

colonel_claypoo Over a year ago

Putting [datetime] in front of the variable makes it work for me.

Collectives™ on Stack Overflow

How to convert string dates in PowerShell?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related