Skip to Content
0
Former Member
Sep 18, 2008 at 09:23 PM

Need To Check For Nulls And Force A Date

134 Views

I'm trying to check to see if a field is blank (null or blank), if so, force a date into it. My formula is giving me zeros. What is wrong with the below formula ?

If {Sales_Primary.Type_Of_Sale} = 1 And

Isnull() Then 1999-01-01