Find-Item Add support for GreaterThan LessThan when searching by date and number

[michaellwest]

I would like to have the following work:

$criteria = @(
    @{Filter = "LessThan"; Field = "__smallupdateddate"; Value = [datetime]"08/01/2019"} 
)
$props = @{
    Index = "sitecore_master_index"
    Criteria = $criteria
}

Find-Item @props

$criteria = @(
    @{Filter = "GreaterThan"; Field = "size"; Value = 1000} 
)
$props = @{
    Index = "sitecore_master_index"
    Criteria = $criteria
}

Find-Item @props

[michaellwest]

Noticed that if I want to adhere to the time in UTC, the datetime object should be created in UTC.

$date = New-Object DateTime 2019, 8, 1, 0, 0, 0, ([DateTimeKind]::Utc)

$criteria = @(
    @{Filter = "LessThan"; Field = "__smallupdateddate"; Value = $date} 
)
$props = @{
    Index = "sitecore_master_index"
    Criteria = $criteria
}

Find-Item @props