Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Try This And See If You Get Any Results From The Code In The Question

Would someone try the below code and see if 9/9/1999 shows up. "{TableName.Sales_Date}" is a date-time field ? Thanks ! ! !

If {Sales_Primary.Type_Of_Sale} = 1 And

Isnull({TableName.Sales_Date}) Then #9/9/1999#

Else

{TableName.Sales_Date};

Former Member
replied

Hi Lenell,

Try this instead:

If {Sales_Primary.Type_Of_Sale} = 1 And

Isnull({TableName.Sales_Date}) Then Date (1999, 9, 9)

Else

{TableName.Sales_Date};

Also go to File | Report Options and see if you have Convert Database Null Values to Default and Convert Other Null Values to Default turned on.

If these are on then try:

If {Sales_Primary.Type_Of_Sale} = 1 And

{TableName.Sales_Date} = Date (0,0,0) Then Date (1999, 9, 9)

Else

{TableName.Sales_Date};

Most likely it's how Crystal is handling the NULLs that's the problem.

Good luck,

Brian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question