Powershell Datetime::Parseexact with multiple formats

Question

I am trying to use parseexact , however the dates that I have are in multiple formats. I tried

$format =@('yyMMddHHmm') 
[System.DateTime]::ParseExact('1605221412',$format,$null)

and everything is fine When I try to add another format I get an exception

$format =@('yyMMddHHmm', 'yyyyMMddHHmm') 
[System.DateTime]::ParseExact('1605221412',$format,$null,[System.Globalization.DateTimeStyles]::None)

I tried double quotes, writing inline , various ways of trying to pass an array as the second argument.

[System.DateTime]::ParseExact('1605221412','yyMMddHHmm, yyyyMMddHHmm',$null,[System.Globalization.DateTimeStyles]::None)

What am I missing ? Is it possible to use ParseExact for multiple formats without doing a bunch of if, then , else statements ?

Santiago Squarzon · Accepted Answer · 2023-06-14 21:30:11Z

3

You are doing it just fine, the only problem is that @(..) is object[] not string[]:

$datesToTest = '1605221412', '09/02/2022', '02-09-2022'
[string[]] $formats = 'yyMMddHHmm', 'yyyyMMddHHmm', 'dd/MM/yyyy', 'dd-MM-yyyy'
$datesToTest | ForEach-Object {
    [datetime]::ParseExact(
        $_,
        $formats,
        [cultureinfo]::InvariantCulture,
        [System.Globalization.DateTimeStyles]::None)
}

See ParseExact(String, String[], IFormatProvider, DateTimeStyles).

edited Jun 14, 2023 at 21:30

answered Feb 9, 2022 at 19:56

Santiago Squarzon

65.6k5 gold badges26 silver badges60 bronze badges

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

2 Comments

GoGoPuffs Over a year ago

Thanks. Just learning Powershell now

Santiago Squarzon Over a year ago

@GoGoPuffs happy to help :)

Collectives™ on Stack Overflow

Powershell Datetime::Parseexact with multiple formats

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related