Formatting Dates in PowerShell

Question

I am currently trying to convert a date from the one displayed in regedit to a readable datetime format. But I do not know how to do this, I'm working with the following:

.GetValue('InstallDate')

And in the .csv file, it display it as this: 20150914

How would I go about converting that into a readable date?

It would be helpful if you posted the whole code where you take the value from registry and place it in the csv (not that I would not know how to do it, I am more curious about how you do it) — Santhos
– Santhos, Commented Oct 14, 2015 at 13:55

CB. · Accepted Answer · 2015-10-14 10:34:25Z

1

try

[datetime]::Parseexact("20150914","yyyyMMdd", $null  )

answered Oct 14, 2015 at 10:34

CB.

61.3k9 gold badges170 silver badges165 bronze badges

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

Comments

cloudbase · Accepted Answer · 2015-10-23 19:48:49Z

1

I'm not sure why you down voted the other answer because he is right on the money with [Datetime]::ParseExact you will have to deal with the null values though

    $Regbase = Get-ChildItem HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\
    foreach ($entry in $regBase)
    {
    $date = (Get-ItemProperty HKLM:\$entry | select installdate).installdate
        try
        {
            [DateTime]::ParseExact($date, "yyyyMMdd", [CultureInfo]::InvariantCulture) 
        }
        catch [exception] 
        {
            "Date Value: $date" 
        }
    }

edited Oct 23, 2015 at 19:48

answered Oct 23, 2015 at 16:57

cloudbase

234 bronze badges

Comments

qxg · Accepted Answer · 2015-10-14 10:35:25Z

0

PowerShell Date is just .NET DateTime. Check DateTime.ParseExact.

[DateTime]::ParseExact("20151010", "yyyyMMdd", [CultureInfo]::InvariantCulture)

answered Oct 14, 2015 at 10:35

qxg

7,0961 gold badge31 silver badges37 bronze badges

1 Comment

Sohail Arif Over a year ago

Where would I place that? - this is the complete string: ($RegBase.OpenSubKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\$_")).GetValue('InstallDate')

Collectives™ on Stack Overflow

Formatting Dates in PowerShell

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related