Convert Dates in Powershell but Format Not Recognized

Question

I'm trying to use powershell to convert a string that contains RFC 2822 formatted dates into another format. Right now I'm getting an error saying my string was not recognized as a valid DateTime.

Write-Host ([Datetime]::ParseExact('Thu Oct 07 09:23:26 UTC 2021', '[R][1]', $null)).ToString("yyyyMMdd")

I'm not sure what I'm doing wrong.

what format pattern does R give?

Lee_Dailey
– Lee_Dailey

2021-10-14 10:04:46 +00:00
Commented Oct 14, 2021 at 10:04 — Lee_Dailey
– Lee_Dailey, Commented Oct 14, 2021 at 10:04

Mathias R. Jessen · Accepted Answer · 2021-10-14 10:38:52Z

2

The R standard datetime format string specifier does not describe the format you've supplied.

You're gonna need a custom format string:

[Datetime]::ParseExact('Thu Oct 07 09:23:26 UTC 2021', 'ddd MMM dd HH:mm:ss UTC yyyy', $null)

answered Oct 14, 2021 at 10:38

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

Convert Dates in Powershell but Format Not Recognized

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related