Casting a column from csv as date powershell

Question

Casting a column from csv as date powershell

I have a csv that looks like this

"fundName","MMFcusip","ticker","AsOfDate","SumHoldingPercent"
"BlackRock OH Muni MMP/Instit","'091927236'","COIXX","2/29/2012 12:00:00 AM","100.00000000200"
"Western Asset Inst US Treas Res","'52470G841'","CIIXX","2/29/2012 12:00:00 AM","100.00000000200"

Using powershell, how can I use "asOfDate" as the date / time when using the import-csv cmdlet?

EDIT: this is the line of code I'm working with now

$measuredDate = $today.AddDays(-21)
$staleDates = Import-Csv d:\path\file.csv | Foreach-Object {$_.AsOfDate = Get-Date $_.AsOfDate} | Where-Object {asOfDate -lt $measuredDate} | Measure-Object

+5

date casting powershell csv

mhopkins321 May 14, '12 at 14:26

source share

1 answer

Shay levy · Accepted Answer · 2012-05-14T14:47:48+0000

Import-Csv file.csv |
Where-Object { ![string]::IsNullOrWhiteSpace($_.AsOfDate) } | 
Foreach-Object {
   $_.AsOfDate = $_.AsOfDate -as [datetime]
   $_
}

Casting a column from csv as date powershell

More articles: