I am not quite clear what your scenario is, but going by what you say, you just need to draw that date ("Besoin_CMD_Corrige") from the record with the largest date?
That's rather easy:
- Sort your table (only possible in a RESIDENT LOAD, not in the primary LOAD) by that date in asc. order
=> The largest date will be the very last record.
- Then use the PEEK() function to get that date into a variable - without a number as parameter (only the fieldname as parameter), it automatically uses the record that was loaded the very last - that would then be the one with the largest date.
=> You can use that variable for your comparison.
I try the Peek() solution and it work but not 100% for me.
When I have a single valur for "Besoin_CMD_Corrige" field, the peek() function return a wrong date but when It is not single that's work.
Also I only success with the Peek() function when I use it in a chart as expression, not in the script.
Best regards Jérôme