Problem sort/filtering a gallery by date...

[Aaron_Kapala]

Hi there,

I wonder if you can help, i recently got some help with filtering and searching a gallery and the problem was solved for me except for one thing. The Sort option i wanted was to ascend and descend by Date but i also wanted to allow my team to search for a date, i can't currently get it to work, here is what i have.

My gallery is called 'BrowseGallery1_2', my data is 'BillableUtilisation' my field for the Date is called 'DateRecord' but due to the american format, i had to amend the field to the following: 'Text(ThisItem.DateRecord, "[$-en-US]dd/mm/yyyy")'.

Here is the code for the sort/filter for the Gallery:

SortByColumns(Filter(Search(BillableUtilisation,TextSearchBox1_2.Text,"ClientNameRecord","ProjectTitleRecord","VoucherPotRecord") ,StaffNameRecord = BrowseGallery1_1.Selected.b_CategoryName), "VoucherPotRecord",If(SortDescending1,Descending,Ascending))

This works fine, but if i add in "DateRecord" into that formula it will not work, is there a way i can get round this so that we can sort and search by Date?

Appreciate your help.

Thanks, Aaron