how do i add a date of >= to this formula 1

[willpp]

if isnull({CLCONT.Type}) or
{CLCONT.Type} <> "UDES" then
"" else
{CLCONT.Type}

something like this

{CLCONT.Date of Contact} >= Date (2010, 02, 01)

any help would Grateful

PW

 

[Madawc]

I'd have thought

if (isnull({CLCONT.Type}) or
{CLCONT.Type} <> "UDES") and
{CLCONT.Date of Contact} >= Date (2010, 02, 01)
then "" 
else
{CLCONT.Type}

What's the problem?

If the data is not what you expect, try

{CLCONT.Date of Contact} >= Date (2010, 02, 01)

as a separate formula. Put it with the data, maybe in a test section, and see if it works OK.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[willpp]

thanks Madawc
did not think to put the Bracket before the isull