How to put this in Formula screen?

[bloomlight]

How to put the following code to Crystal Report formula screen?

{StartDate <= '01/31/2010' and DischargeDate >= '01/01/2010'} or {StartDate <= '01/31/2010' and DischargeDate is null)

When using this code on SQL server to generate a report, it works well. But when I try it on crystal report, the report only shows client who discharged. It seems that only the first part the code gets executed. I need a report which will show me the active clients during the month of Jan 2010. How can do that? Thanks.

 

[lbass]

Are your date fields of date datatype or are they really strings? If they are dates, the syntax should be as follows, with the null check first before the field is referenced again. The parens are necessary, too:

{table.startdate} <= date(2010,1,31) and
(
isnull({table.dischargedate}) or
{table.dischargedate} >= date(2010,1,1)
)

-LB

 

[bloomlight]

It worked. Thank you soooooo much.