Changing datetime format in csv files - Batch Scripting/ Powershell [closed]

If your csv files have proper column headers, then using PowerShell you can do the following to look for any field in the file having a date in MM/dd/yyyy hh:mm:ss tt format and update it with the preferred format dd-MMM-yyyy HH:mm:ss like this:

$sourceFolder = 'X:\Path\to\where\the\csv\files\are'
$testDate     = Get-Date  # just any DateTime object to use with TryParseExact()

# get the files from the path and loop through
Get-ChildItem -Path $sourceFolder -Filter '*.csv' -File | ForEach-Object {
    $csv = Import-Csv -Path $_.FullName

    # get the header names from the first row
    $headers  = $csv[0].PSObject.Properties.Name
    # loop through all data rows in the csv. (each row is a PSObject with properties)
    foreach($item in $csv) {
        # loop through all properties (fields) in the item
        foreach($name in $headers) {
            # see if this is a date in the expected format
            if ([DateTime]::TryParseExact($item.$name, 'MM/dd/yyyy hh:mm:ss tt',[cultureinfo]"en-US", 0, [ref]$testDate)) {
                $item.$name = '{0:dd-MMM-yyyy HH:mm:ss}' -f $testDate
            }
        }
    }
    # if you like, output on screen
    $csv | Format-Table -AutoSize

    # output to new CSV file
    $out = Join-Path -Path $_.DirectoryName -ChildPath ('{0}-Updated{1}' -f $_.BaseName, $_.Extension)
    $csv | Export-Csv -Path $out -NoTypeInformation
}