Hi @BaptisteP ,
Do you want to check dates in 5 datepickers and these dates could be blank?
Yes, this is a little complex. Because you do not know which datepicker will be blank.
I suggest you use collection in your issue.
I've made a similar test for your reference:
1)insert 5 datepickers, named DatePicker1,DatePicker1_1,DatePicker1_2,DatePicker1_3,DatePicker1_4
set every datepicker's IsEditable to true
(then these datepickers could be blank value)
2)set every datepickers' OnChange:
ClearCollect(dates,{name:1,date:DatePicker1.SelectedDate},{name:2,date:DatePicker1_1.SelectedDate},{name:3,date:DatePicker1_2.SelectedDate},{name:4,date:DatePicker1_3.SelectedDate},{name:5,date:DatePicker1_4.SelectedDate})
//save all the dates in a collection
3)use a label to check, if the result is true, then "date_1 ⩽ date_2 ⩽ date_3 ⩽ date_4 ⩽ date_5", or else will be false
set the label's Text:
First(Sort(Filter(dates,!IsBlank(date)),name)).date<=Last(FirstN(Sort(Filter(dates,!IsBlank(date)),name),2)).date&&
//date1<=date2
Last(FirstN(Sort(Filter(dates,!IsBlank(date)),name),2)).date<=Last(FirstN(Sort(Filter(dates,!IsBlank(date)),name),3)).date&&
//date2<=date3
Last(FirstN(Sort(Filter(dates,!IsBlank(date)),name),3)).date<=Last(FirstN(Sort(Filter(dates,!IsBlank(date)),name),4)).date&&
//date3<=date4
Last(FirstN(Sort(Filter(dates,!IsBlank(date)),name),4)).date<=Last(Sort(Filter(dates,!IsBlank(date)),name)).date
//date4<=date5
use filter to only get not blank dates and use sort to sort the result based on datepicker name.
Best regards,
