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
I dont think so It works go for string variable and put it in the condition like if..else..then
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