Advance Help Needed With #num!

[Guest]

I have tried to get answers before with no help, so now I have two problems.
First, I am linking to excel and whatever fields contain blanks, I am getting
a #num! error. I can filter out most with an <>0 in the condition field of a
query. However I have run into a problem I can not fix. I have two dates,
date1 and date2. I created a field in a query as followes
RD:iif([date1]<>0,[date1],[date2]) and it does not work. What I am trying to
do is if a date is found in date1 use it, if not, use date2. Because of the
#num! promblem, I can not get the iif statement to work. Please someone help
me!

Chris

 

[Guest]

Try this --
RD:iif([date1] Is Not Null,[date1],[date2])

If the field is null it is not zero. Zero is a value but Null has no value.