The following formula almost meets my needs. What I need is
if SCI1 is null, then null
if SCI1 is not null, then if SCI1 is before 1/7/08 then "Y", if SCI1 is
not
before 1/7/08 then "N"
=IIf([SCI1]<>"" And ([SCI1]<="1/7/2008"),"Y","N")
How do I add that if it is null, leave this field blank?
