Convert String to Date in Powershell

Question

Today I met a problem with the conversion of this type of string "8/3/2020 10:29:33 AM" which I need to convert to date format.

I try this type of command and get an error every time:

$PwdExpiracy = "8/3/2020 10:29:33 AM"
$date = [datetime]::ParseExact($PwdExpiracy,'MM/dd/yyyy HH:mm:ss tt',$null)

The error is :

Exception calling "ParseExact" with "3" argument(s): "String was not recognized as a valid DateTime."
Au caractère Ligne:1 : 1
+ $date = [datetime]::ParseExact($PwdExpiracy,'MM/dd/yyyy HH:mm:ss tt',$nu ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : FormatException

Could you help me with this ? That would be very kind of you!

Mathias R. Jessen · Accepted Answer · 2020-06-27 16:53:35Z

3

You're using format specifiers for dates with leading zeroes and 24-hour time - change to the following:

$date = [datetime]::ParseExact($PwdExpiracy, 'M/d/yyyy hh:mm:ss tt', $null)

M is the month without leading zeroes
d is the day without leading zeroes
hh is the hour in 12-hour time (AM/PM)

If you still receive "String was not recognized as a valid DateTime.", try forcing ParseExact() to use the InvariantCulture (roughly equivalent to en-US locale), and it should accept it:

$date = [datetime]::ParseExact($PwdExpiracy, 'M/d/yyyy hh:mm:ss tt', [cultureinfo]::InvariantCulture)

edited Jun 27, 2020 at 16:53

answered Apr 14, 2020 at 12:53

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Comments

Wai Ha Lee · Accepted Answer · 2020-06-12 02:32:09Z

0

Mathias R. Jessen said in a comment:

The exact same "String was not recognized as a valid DateTime.".

Can you try:
[datetime]::ParseExact($PwdExpiracy,'M/d/yyyy hh:mm:ss tt',[cultureinfo]::InvariantCulture)

which worked for me.

edited Jun 12, 2020 at 2:32

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered Jun 11, 2020 at 13:27

Noemie

1411 silver badge12 bronze badges

Collectives™ on Stack Overflow

Convert String to Date in Powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related