Hi,
In my gallery, i have two textinputs that filters the gallery by name and jobnumber. If nothing is entered in the textinputs, the date range sorts in descending order, however once they filter by name and or jobnumber, the dates are all over the place. Any ideas on how i can get the gallery to filter by descending date regardless of what search's are entered in the textinputs? Any help would be much appreciated.
This is what i have on the onselect of the gallery
Sort(Filter(TimeSheetCollect,StartsWith(Name, UserName.Text),
StartsWith(JobNumber,TextInput5.Text)) ,Date,SortOrder.Descending)
