Crystal Report Formula Help Needed

It is a real date field (Constituency Code Date To."

The data source is an export to .mdb


Trying:

If ((IsNull({CnCnstncy_1.CnCnstncy_1_Date_To}) or ({CnCnstncy_1.CnCnstncy_1_Date_To} > CurrentDate)) then "Current" else "Past"


 as Joshua suggested, but it is saying a ) is missing.


Thanks for your help, everyone!

 

John Heizer:

Is it a real date field (like a Gift Date), or a fuzzy date field (like a Constituency Date)?  Is your data source an Export to Blackbaud Report Writer database, another Export format, or a direct ODBC connection to the live data?

OK, with the help of Ron at Blackbaud we got this sorted. Crystal was not reading the Cons Code Dates as Dates, so we had to make a conversion formula to translate it into dates:


If InStr({CnCnstncy_1.CnCnstncy_1_Date_To},",") <> 0 then

  Right({CnCnstncy_1.CnCnstncy_1_Date_To}, Length({CnCnstncy_1.CnCnstncy_1_Date_To}) - (InStr({CnCnstncy_1.CnCnstncy_1_Date_To},",")+1))

else

  ""


Then used this formula to make it "Past" or "Current":

If {@DateToConvert} = "" 

then

  "Current"

else if isdate({@DateToConvert}) then

 (

   if Date({@DateToConvert}) > CurrentDate

   then "Current" else "Past"

 )

else

  "test"


Thanks for your help everyone!!!