I'm new at the community and are going about to make my first Projekt with set expressions. I've got the basic understanding of the set expressions. The problem ist, when I try to make an expression with a little bit more complexity.
For example:
There is a time line and i wanna know from a specific time X, whats the next available date, that is smaller than time X.
The time stamps beloging to products and one product has severall timestamps, that are in the historie table
time X
-----------------I--------------I------------>
max(Date)<X
I tried it like this:
1) count({<Date={'<timeX'}>}GGN) this Expression works fine, but gives out all possible Dates that are smaller than X
2) I need to add in to 1) a max statement, so that only the biggest date will be selected or maybe there is some other solution
