powershell - Remove duplicates from array based on date -

in powershell have array i've imported csv following information

 username           recorddate  @{username=user1;  recorddate=05/18/2013} @{username=user1;  recorddate=05/18/2012} @{username=user1;  recorddate=04/18/2013} @{username=user1;  recorddate=01/18/2013} @{username=user22; recorddate=05/18/2013} @{username=user22; recorddate=05/18/2012} @{username=user22; recorddate=04/18/2013} @{username=user22; recorddate=01/18/2013} 

i want remove duplicated entries based on date , leave entry latest date each user in username

thank you!!

try this:

import-csv "c:\path\to\your.csv" `   | select username, @{       n='recorddate';       e={[datetime]::parseexact($_.recorddate, 'mm\/dd\/yyyy', $null)}     } `   | group username `   | % { $_.group | sort recorddate -desc | select -first 1 }