Select Expert, excluding a Null Date/time 1

[ziggs]

I have a report that is set up in the options as "Convert Null Field Value to Default". It must stay that way so that I can get other formulas to populate correctly.

Now, I want to exclude all incidents in which a particular Date/Time field is Null.

Given the above criteria, what select expert formula should I add?

If it helps, here is my current Select Expert formula:

{INCIDENT_LOC_EVENTS_VW.INCD_CALL_TIME} in {?Start Date} to {?End Date} and
not ({INCIDENT_LOC_EVENTS_VW.INCD_DISPO_NUM} like "1022&quot and
{INCIDENT_LOC_EVENTS_VW.INCD_CLSFN_NUM} like "27D*"

Thanks!

 

[kenhamady]

Any condition that includes this field will exclude null dates. So if you add a rule that says something like:

{your.datetime} > DateTime(1900,1,1,0,0,0)

It should skip the null dates. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal