Set analysis

[kmswetha]

Hi ,

I have to write the below condition in set analysis.

Today()-Run_date<=30.

How do I write this in Set analysis.

Regards,

Swetha

[sunny_talwar]

May be this:

{<Run_date = {"=Today() - Run_date <= 30"}>}

[kmswetha]

This is working, But I Have to also add <=30 and >60.

Also can you explain me how this works?

[sunny_talwar]

How can the above be true? something can be less than and equal 30, but cannot be simultaneously greater than 60? Do you mean <=30 or >60??

[kmswetha]

<30 and >=60

[sunny_talwar]

If I am right, try this:

{<Run_date = {"=(Today() - Run_date) <= 30 or (Today() - Run_date) > 60"}>}

[kmswetha]

Sorry >30 and <=60.This is correct one,

[sunny_talwar]

Are you trying to get between 30 to 60?

[sunny_talwar]

Try this:

{<Run_date = {"=(Today() - Run_date) > 30 and (Today() - Run_date) <= 60"}>}

[sunny_talwar]

If this for some reason doesn't work, you can also try this:

{<Run_date = {"=(Today() - Run_date) > 30"}*{"=(Today() - Run_date) <= 60"}>}