Vista - comparing dates to $null

I'm trying to find records matching a date within a certain amount of
time. Some of the source fields have no date specified and are
instead $null. As a result, I get some obvious errors. What is the
best way to structure my queries to avoid this error?

snippet:
$recentXpu = $xpu | ? { $_.StartDate -ge
[DateTime]::Now.AddDays(-60) }

error:
At line:1 char:41
+ $recentXpu = $xpu | ? { $_.StartDate -ge <<<<
[DateTime]::Now.AddDays(-60) }
The '-ge' operator failed: Could not compare "" to "6/28/2007 11:10:51
AM". Error: "Cannot conver
t value "6/28/2007 11:10:51 AM" to type "System.DBNull". Error:
"Object cannot be cast to DBNull.
"".
is $null it doesn't fit my criteria and should be tossed out.

I'd like to comfortably stay within one-liner territory which is where
I'm stalled.

"Hal Rottenberg" <halr9000@xxxxxx> wrote in message
news:1188227821.147518.250490@xxxxxxHow about this?

$recentXpu = $xpu | ? {$_ -and $_.StartDate -ge
[DateTime]::Now.AddDays(-60) }

--
Keith

Try comparing $_.StartDate to $null:

$recentXpu = $xpu | ? { $_.StartDate -ne $null -and $_.StartDate -ge
[DateTime]::Now.AddDays(-60) }

--
Kiron

On Aug 27, 11:49 am, "Keith Hill [MVP]"YES! I knew there was something easy that had not occurred to me.

Thanks Keith & Kiron.

Since [dbNull] is the cause of -ge "Could not compare "System.DBNull" check
for this type instead:

$recentXpu = $xpu | ? { $_.StartDate -isNot [dbNull] -and $_.StartDate -ge
[DateTime]::Now.AddDays(-60) }

--
Kiron

"Keith Hill [MVP]" <r_keith_hill@xxxxxx_no_spam_I> wrote in message
news:081B7CCE-4644-45A0-8A3E-021724353A3A@xxxxxxOops. Should have been:

$recentXpu = $xpu | ? {$_.StartDate -and $_.StartDate -ge
[DateTime]::Now.AddDays(-60) }

No need to compare explicitly to $null unless 0 is a valid value (since 0
evaluates to false).

--
Keith