Change date format in CSV using PowerShell

Question

I'm new to PowerShell and I have a CSV file where I need to change the format of the dates in 2 columns (as shown in the example below) to the format dd/mm/yyyy.

"First Name","Last Name","Employee Number","Course Name","Completion Status","Date_Started","Completion_Date"

Joe,Bloggs,8632,"Test Name",Complete,"26 Nov 2015","26 Nov 2015"

Does anyone know how to achieve this using PowerShell?

JPBlanc · Accepted Answer · 2015-11-26 17:19:54Z

1

You can try this :

Import-Csv D:\temp\test.csv | % {$_.Date_Started = ([datetime]($_.Date_Started)).ToString('dd/MM/yyyy');$_.Completion_Date = ([datetime]($_.Completion_Date)).ToString('dd/MM/yyyy');$_} | Export-Csv 'D:\temp\testBis.csv' -NoTypeInformation

You can try [datetime]::ParseExact(...) to parse special dates.

answered Nov 26, 2015 at 17:19

JPBlanc

73k17 gold badges137 silver badges180 bronze badges

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

Collectives™ on Stack Overflow

Change date format in CSV using 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