Not greater than symbol in Data Services

[former_member186894]

Hi, We can use symbol in SQL server called !>. Do we have any idea to use same in Data Services too.

Actually, I have a scenario where I have to check date and time that should not be between 10AM  and 12 PM.

Any help would be appreciated.

Thanks,

Imran

[former_member186894 · Accepted solution]

I got the answer of my question.

if(not($var<='datetime' and $var>='datetime'))begin

end

Thanks,

Imran

[former_member187605]

Use <=. That's identical to !>.

[former_member186894]

Hi Dirk, Can you please explain little more. I did not get your answer.

Thanks,

Imran

[former_member187605]

There's no difference between 1 <= 2 and 1 !> 2, is there?

This valid for all numeric, date, character... values.