Comparing Multi-Value Dates in Query View

HCL Domino Domino Forum
1

Does anyone know how to compare dates in a query view selection formula when the date field is multi value?

I can get documents with a single value date that is < @Now. But I can’t figure out how to get docs where the dates are multi value. Since the exploding to show multi value as separate entries happens on the notes side, I’m guessing that DB2 is comparing the whole concatenated date string, but I don’t know what to do about it.

Anyone run into this?

2

Subject: One idea

is to “explode” the date on the DB2 side.

I think it can be done by creating a temporary table in your sqlquery - via a UDF - that would explode the dates.

Maybe this can help

3

Subject: Thanks

I ended up switching to a normal notes view for a different reason, but that article helps with another problem I was having. Thanks :slight_smile: