If you are unable to create a new account, please email support@bspsoftware.com

 

Attempting to create a boolean variable with an "OR" for use in a cond format

Started by cepete02, 16 Oct 2008 10:23:54 AM

Previous topic - Next topic

cepete02

Hello,

I am attempting to create a boolean variable with the following condition in it:

(_months_between([Query1].[today],[Query1].[Time stamp]) >= 3) or ([Query1].[Time stamp] is null)

Unfortunately, it doesn't work.  If I create a variable with either the first, or the second condition in it, it works fine, but not in one condition with an "OR" between them. 

Any assistance would be greatly appreciated.

Carl

jahnavi

I dont think so It works go for string variable and put it in the condition like if..else..then

cepete02

Thanks Jahnavi,

I did try that, and it didn't work.  It seems that when I put the _months_between() into the condition, the "field is null" portion stops working no matter what conditional structure I use.  I can't believe, though, that there isn't a way to do this, somebody out there must be doing this same thing!

Thanks Again,

Carl