G GPSPOW Registered User. Local time Today, 13:42 Joined Apr 25, 2012 Messages 27 May 18, 2012 #1 How do I write the build expression to do the following: IIF( isnull(Field1) and isnull(field2), 1, datediff('d',now(), dateserial(2012,4,30)) I am having a problem with the "and" clause. Thank you GPSPOW
How do I write the build expression to do the following: IIF( isnull(Field1) and isnull(field2), 1, datediff('d',now(), dateserial(2012,4,30)) I am having a problem with the "and" clause. Thank you GPSPOW
pr2-eugin Super Moderator Local time Today, 21:42 Joined Nov 30, 2011 Messages 8,494 May 18, 2012 #2 Really? I could not see anything wrong with the expression.. Try this.. IIF(IsNull([Field1]) And IsNull([Field2]), 1, DateDiff("d",Date(), DateSerial(2012,4,30))
Really? I could not see anything wrong with the expression.. Try this.. IIF(IsNull([Field1]) And IsNull([Field2]), 1, DateDiff("d",Date(), DateSerial(2012,4,30))
G GPSPOW Registered User. Local time Today, 13:42 Joined Apr 25, 2012 Messages 27 May 18, 2012 #3 Thank you.
pr2-eugin Super Moderator Local time Today, 21:42 Joined Nov 30, 2011 Messages 8,494 May 18, 2012 #4 Did it work? Was there any problem?
