Removing row's by closest Date

[Marv0Mat]

Hello there,

i have some duplicated rows in a table which differ in a Date("Datum_Verbund") and an Object Number ("Fz_Nr_Verbund").

I only want the rows, which are the closest to the Date "Beg_Datum" but not newer then it, like this:

But i can't use the Max Date cause the Date "Beg_Datum"  can be older then the Date "Datum_Verbund".

Thank you in advance!

[MarcoWedel]

are you looking for a front end or a script solution?

[Marv0Mat]

I'm looking for a script solution. In the meantime i have done it by myself. I made a Mappingtable with the condition: not newer then Beg_Datum and then the newest. I applyed the map and only took the rows where the Datum_Verbund is the same like my Mapped Date. But let me know if there is an easyer way to do it 😉