Conditional question

[#1]

Hello,

I need to build a filter with yes/no values.

The yes part is conditioned by:

For the same id (CNP&SASIU) I can have multiple entries with start date(datainasg) and end date(dataoutasg).

If between 2 entries

dataoutasg(entry1) - datainasg(entry2) is 0

and

dataoutasg(entry2) - datainasg(entry2) >30,

then condition is true and the filter should show "yes", if not "No".

I am open to suggestions/solutions/opinions.

Thank you

[sujeetsingh]

Bogd ,

Try using just interval function in script

interval(date1-date2,'d')

Hope it help.