Please help with formula for CR XI

[jasona45]

I need a formula that will show anything that is greater than or equal to {incident.pt_stop_date} and that will also display blank fields for {incident.pt_stop_date}.

Thanks

 

[dgillz]

If "what" is greater than or equal to {incident.pt_stop_date}?

Another database field? A parameter?

It is impossible to accurately answer your question as worded.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[jasona45]

{incident.pt_stop_date} greater than or equal to 5/01/06 and any blank fields

Sorry

 

[lbass]

Try:

isnull({incident.pt_stop_date}) or
{incident.pt_stop_date} = date(0,0,0) or
{incident.pt_stop_date} >= date(2006,05,01)

This assumes you were referring to May 1, and that your field is a date type field.

-LB