Forum

HomeHomeCoreCoreGeneralGeneralIIF and Compound CriteriaIIF and Compound Criteria
Previous
 
Next
New Post
2/17/2011 2:44 AM
 

Please see post below...

 

New Post
2/17/2011 2:56 AM
 

 

Can anyone tell me how to compare a NULL date value in an IIF statement?

{IIF "@StartDate <> NULL", "True", "False"}

The syntax above doesn't work.

 

New Post
3/4/2011 1:30 AM
 

How about putting single quotes around @StartDate and then using a pair of them for the right-hand side

 

{IIF "'@StartDate' <> ''", "True", "False"}
New Post
3/4/2011 7:02 AM
 

 Query variables are ONLY rendered in Queries. Thats more than likely your issue. If you want to use them within OWS syntax, you need to put it this way: [@StartDate,Variable]


Kevin M Schreiner
Open Web Studio
Previous
 
Next
HomeHomeCoreCoreGeneralGeneralIIF and Compound CriteriaIIF and Compound Criteria


 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share