Converting string to date time in powershell

Question

I am trying to parse filenames (strings) and convert them to dates in powershell using the following line:

([datetime]::ParseExact($DirName.BaseName,'yyyyMMdd',$null)

The problem is, not all of the folders in that directory following that naming convention. How would I first test to see if the folder fits the naming convention and if it does, convert it to a date time object? Any help would be greatly appreciated.

Use RegEx. That way you could detect different patterns and act on them with specific solutions. — Martin Maat
– Martin Maat, Commented Jun 25, 2016 at 7:49

Ansgar Wiechers · Accepted Answer · 2016-06-24 19:14:58Z

2

I wouldn't bother checking first. Just put the call in a try..catch block. I would recommend using InvariantCulture rather than $null, though.

$culture = [Globalization.CultureInfo]::InvariantCulture
try {
  [datetime]::ParseExact($DirName.BaseName, 'yyyyMMdd', $culture)
} catch {
  # not a valid date
}

answered Jun 24, 2016 at 19:14

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

Converting string to date time in powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related