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

[kmswetha]

This is not working for me

[sunny_talwar · Accepted solution]

And what about this one?

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

[kmswetha]

Even this is not working.Syntax is correct but it is not considering the set.

[kmswetha]

Hi SunIndia,

Latest is working.

But am curious how would Run_date hold >30 condition?

[sunny_talwar]

Not sure I understand what you are curious about??? Run_date hold > 30 condition???

[sunny_talwar]

I am not sure I understand what you wanted to know? Let me know if you would need any clarification and I will be more than happy to help.

Best,

Sunny

[kmswetha]

Hi,

In the below expression

how is it working when Run_date is equated to Today() - Run_date <= 30, though we are actually looking days between today and rundate?

[sunny_talwar]

We are not telling it to show us the Run_date = Today() - Run_date <= 30, instead we are telling the expression to pick only those rows where Today() - Run_date <= 30. You might be able to use another field in place of Run_date (preferably unique field) to test the condition as well.

I hope this make sense?

Best,

Sunny

[kmswetha]

Thx Sunny.Now I get the point.

[sunny_talwar]

No problem at all

Glad I was able to help.