G GPSPOW Registered User. Local time Today, 15:28 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, 23:28 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, 15:28 Joined Apr 25, 2012 Messages 27 May 18, 2012 #3 Thank you.
pr2-eugin Super Moderator Local time Today, 23:28 Joined Nov 30, 2011 Messages 8,494 May 18, 2012 #4 Did it work? Was there any problem?
