Compare dates from a string in PowerShell [duplicate]

Question

$Deldate = "19-06-2018"
$Newdate = "04-06-2018"

I need to check which date is bigger.

if ($Deldate -ge $NewDate) {
    write-host "NewDate is bigger"
} 
else {
    write-host "Deldate is bigger"
}

This is not working for me, and it looks like the format is not "System.DateTime". I'm getting the date values are from an external CSV file. How do I find a solution for this?

Answer 1

You should be able to cast the strings that you have created to the "datetime" type like so:

$Deldate = "19-06-2018"
$Newdate = "04-06-2018"

$Deldate = [datetime]::ParseExact("$Deldate", 'dd-MM-yyyy', $null)
$Newdate = [datetime]::ParseExact("$Newdate", 'dd-MM-yyyy', $null)

if ($Deldate -ge $NewDate) {
    write-output "NewDate is bigger than or equal to"
}
else {
    write-output "Deldate is bigger"
}

This returns the correct result. You can't simply use the Get-Date cmdlet, since the -Date required parameter also requires that the parameter be of type "DateTime", so you first have to cast the strings to the DateTime type.