Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Bogd ,
Try using just interval function in script
interval(date1-date2,'d')
Hope it help.