Multi Value Field: Extract Only Elements Withing Date

HCL Domino Domino Forum
1

I have a multi-value field, more or less like:

YYYY-MM-DD XXXXXX YYYY-MM-DD

YYYY-MM-DD YYYYYYY YYYY-MM-DD

YYYY-MM-DD ZZZZZZ YYYY-MM-DD

now, i want to have another, computed field, that would only have listed the items that are not overdue.

Ideas?

2

Subject: Multi Value Field: Extract Only Elements Withing Date

Sure you could do something like:

@For(n := 1; n <= @Elements(YOURFIELD); n := n + 1;

@Do(

startDate := @Date(@Middle(YOURFIELD[n]; "<startdate>"; "</startdate>"));

@if(startDate <= @Date(@Now); val := @If(val = ""; YOURFIELD; val : YOURFIELD)

)

);

val