Hi, I´m Alex.
I understant that you need, one way that you can try to solve our problem do it one part at a time.
1º - Create a collect with all items for 2 expressions the filter
ClearCollect(
col_all_items;
Filter(
'Affectations';
'Date de retour prévisionnelle' >= Today() && 'Date de retour prévisionnelle' <= DateAdd(Today); 60; TimeUnit.Days
)
)
Obs: For the test1, check the collect col_all_items to show the correct data
2º - If the data are correct add another filter expressions
ClearCollect(
col_all_items;
Filter(
'Affectations';
('Date de retour prévisionnelle' >= Today() && 'Date de retour prévisionnelle' <= DateAdd(Today); 60; TimeUnit.Days) || 'Date de retour prévisionnelle' >= Today()
)
)
Obs: For the test2, check the collect col_all_items to show the correct data
3º - If the result are correct add another filter expressions
ClearCollect(
col_all_items;
Filter(
'Affectations';
('Date de retour prévisionnelle' >= Today() && 'Date de retour prévisionnelle' <= DateAdd(Today); 60; TimeUnit.Days) || 'Date de retour prévisionnelle' >= Today() || LookUp(your_table;Immatriculation.Id = Immatriculation.id && Kilométrage >= 2000; true)
)
)
Obs: For the test3, check the collect col_all_items to show the correct data
If the result of col_all_itens are correct, you can modify in your code.
Obs: I can´t understant your express
LookUp(your_table;Immatriculation.Id = Immatriculation.id && Kilométrage >= 2000; true) but the result of lookup could be used to compare >=2000
I hope that you solve your problem.
Best regards
