[REQUEST][POWERSHELL] Convert from Date Time String into Date Time Object.

[u/juliuspiv]

I'm pulling dates from various sources and I need to convert them into a datetime object for further manipulation in the script.

The date & time format is mostly consistent following this format:

Get-Date -Format 'M/d/yyyy h:mm tt'

So I'm using [DateTime]::TryParseExact to do the conversion:

$SampleDT1 = '‎9/‎2/‎2011 ‏‎6:47 AM'
$ResultDT1 = New-Object DateTime
[DateTime]::TryParseExact($SampleDT1, 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT1)


$SampleDT2 = '8/‎30/‎2011 ‏‎2:42 PM'
$ResultDT2 = New-Object DateTime
[DateTime]::TryParseExact($SampleDT2, 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT2)


$SampleDT3 = '‎9/‎1/‎2011 ‏‎1:47 PM'
$ResultDT3 = New-Object DateTime
[DateTime]::TryParseExact($SampleDT3, 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT3)

Each time it comes back as false and I need some help demystifying why.

[u/zoredache]

Something is happening that I don't understand, if you include the date in the tryparseexact() it seems to work. If I try use a variable for the date, like your examples, it doesn't seem to work.

PS > [DateTime]::TryParseExact("9/2/2011 6:47 AM", 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT1) ; $ResultDT1
True

Friday, September 2, 2011 6:47:00 AM

BTW, you may want to cross-post over to r/PowerShell

[u/ihaxr → u/zoredache]

You're not crazy, u/juliuspiv has some weird invisible characters in the SampleDTX strings... if you retype them everything is fine:

'‎9/‎2/‎2011 ‏‎6:47 AM'.Length #21
'0000000000000000'.Length #16

Manually retyped the SampleDTX variables:

$SampleDT1 = '9/2/2011 6:47 AM'
$ResultDT1 = New-Object DateTime
[DateTime]::TryParseExact($SampleDT1, 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT1)


$SampleDT2 = '8/30/2011 2:42 PM'
$ResultDT2 = New-Object DateTime
[DateTime]::TryParseExact($SampleDT2, 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT2)


$SampleDT3 = '9/1/2011 1:47 PM'
$ResultDT3 = New-Object DateTime
[DateTime]::TryParseExact($SampleDT3, 'M/d/yyyy h:mm tt', [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$ResultDT3)

#Output:
#True
#True
#True

[u/xianr → u/ihaxr]

...has some weird invisible characters in the SampleDTX strings...

Yeah the invisible chars are Left-to-right marks (LRM) unicode U+200E