Skip to Content
0
Former Member
Sep 22, 2008 at 04:57 PM

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

20 Views

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};