Multiple isnull() within an expression not working?

[droonu194]

Hello,

I am trying to route my users to a specific website based on multiple isnull() conditions based on dates. I have roughly 6 dimensions I need to check. I've tried the len()>0 and =0 operation. I also tried if(isnull(Customer_Num1_DATE and Customer_Num2_DATE) but no luck.

example:

=if(isnull(Customer_Num1_DATE),
      if(isnull(Customer_Num2_DATE),

'www.newuser.com','www.updatedusers'))

Thank you.

[BrunPierre · Accepted solution]

Hi, What about this or you could post some samples?

Len(Trim(Customer_Num1_DATE)) < 1

[droonu194]

I've tried but it doesn't seem to evaluate it in the chart function.

=if(Len(Trim(1_date_created)) < 1,
if(Len(Trim(2_date_created)) < 1,
if(Len(Trim(3_date_created)) < 1,
if(Len(Trim(4_date_created)) < 1,
if(Len(Trim(5_date_created)) < 1,
if(Len(Trim(6_date_created)) < 1,
'Route to NEW Website','Route to old website'))))))

[BrunPierre]

Is this what you trying to do?

If(Len(Trim(1_date_created)) < 1 and Len(Trim(2_date_created)) < 1 and ...,'Route to NEW Website','Route to old website'))))))