Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi, What about this or you could post some samples?
Len(Trim(Customer_Num1_DATE)) < 1
Hi, What about this or you could post some samples?
Len(Trim(Customer_Num1_DATE)) < 1
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'))))))
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'))))))