Boolean in Filter

Boolean in Filter

  

Hi guys,

I'm trying to make a filter depending on the condition given but I think It doesn't work in aggregate, do you guys have any other idea for this?


Hi allan ,

This wont work with aggregate .You can write it as :

Request.DateSubmitted= if(filterByDate<>NullDate(),FilterByDate,CurrDate())

Cheers,

Rocky

Rocky wrote:

Hi allan ,

This wont work with aggregate .You can write it as :

Request.DateSubmitted= if(filterByDate<>NullDate(),FilterByDate,CurrDate())

Cheers,

Rocky

Hi,

base on your code when the condition is false then the result will become Request.DateSubmitted=CurrDate() what I want is Request.DateSubmitted<>NullDate()

Solution

Hi Allan,

Can try this :

First Filter :

Request.DateSubmitted= if(filterByDate<>NullDate(),FilterByDate,Request.DateSubmitted)

Second filter will be:

Request.DateSubmitted<>NullDate()

I hope it will help you.

Cheers,

Rocky

Solution

Rocky wrote:

Hi Allan,

Can try this :

First Filter :

Request.DateSubmitted= if(filterByDate<>NullDate(),FilterByDate,Request.DateSubmitted)

Second filter will be:

Request.DateSubmitted<>NullDate()

I hope it will help you.

Cheers,

Rocky

This one works!! thanks a lot man!


Cheers!! 


Alway Welcome Allan :)