Find if a Date is Null 1

[CasperTFG]

How would I find if a Database returns NULL or Nothing on a date field.

{T_StatusLogs.SetDT} <= {?Pm-@EndDT} and
({T_StatusLogs.ClearDT} >= {?Pm-@StartDT} or
{T_StatusLogs.ClearDT} = 0)

= 0 does not work, Null does not work? any thoughts on if I can find out it the ClearDT is Nothing.


Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[vidru]

Try:

{T_StatusLogs.SetDT} <= {?Pm-@EndDT} and
({T_StatusLogs.ClearDT} >= {?Pm-@StartDT} or
IsNull({T_StatusLogs.ClearDT}))

-dave

 

[CasperTFG]

That still did not do it?

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[BobSuruncle]

Put the IsNull first

( 
   IsNull( {T_StatusLogs.ClearDT} )
   OR {T_StatusLogs.ClearDT} >= {?Pm-@StartDT} 
)

AND

{T_StatusLogs.SetDT} <= {?Pm-@EndDT}

Bob Suruncle

 

[CasperTFG]

Got it... the Brackets were out of order...

{T_StatusLogs.SetDT} <= {?Pm-@EndDT} and
(IsNull({T_StatusLogs.ClearDT}) or
{T_StatusLogs.ClearDT} >= {?Pm-@StartDT}) and
{T_StatusLogs.ClassUID} = 2

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[Madawc]

Note that all Crystal tests stop when they encounter a Null, and you must always test for them first.

Madawc Williams (East Anglia, UK)