Cannot convert this string to Date object in Powershell

Question

I've been struggling with this for some time now and I've tried everything I could find but, have yet to be successful. I need to convert this string to a Powershell date object:

20180802 16:30:10

Everytime I try ParseExact, it's saying that it doesn't recognize the string as a valid date/time format.

Please show us the actual code (including the format string and the full error) — Mathias R. Jessen
– Mathias R. Jessen, Commented Aug 13, 2018 at 13:49
Possible duplicate of String to DateTime conversion in PowerShell — Josh Withee
– Josh Withee, Commented Aug 13, 2018 at 13:50

Paweł Dyl · Accepted Answer · 2018-08-13 14:16:45Z

4

Following works perfectly:

[DateTime]::ParseExact('20180802 16:30:10', 'yyyyMMdd HH:mm:ss', [CultureInfo]::InvariantCulture)

I bet your problem is 24 hour format.

answered Aug 13, 2018 at 14:16

Paweł Dyl

9,1831 gold badge13 silver badges28 bronze badges

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

Comments

mklement0 · Accepted Answer · 2018-08-13 21:22:02Z

0

Pawel Dyl's helpful answer is the correct and robust solution.

Just to offer a shortcut that may be of interest in similar situations where only a simple textual reformatting is needed in order for a [datetime] cast to recognize a string containing a date/time representation:

Transforming 20180802 16:30:10 to 2018-08-02 16:30:10 would work:

PS> [datetime] ('20180802 16:30:10' -replace '^(\d{4})(\d{2})', '$1-$2-')

Thursday, August 2, 2018 4:30:10 PM  # sample output on a US-English system

Note that a [datetime] cast in PowerShell uses the invariant culture, as PowerShell does in many contexts.

edited Aug 13, 2018 at 21:22

answered Aug 13, 2018 at 21:09

mklement0

452k68 gold badges728 silver badges988 bronze badges

Collectives™ on Stack Overflow

Cannot convert this string to Date object in Powershell

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related