Search by date

[Labraham36]

Hello Community! I have a problem and I don't know how to solve it: My App has the typical home screen with its search engine and a sample of the entered records. What this App does mainly is record a date and data. My problem arose since I need the user to be able to search by putting a date, and not through a text field. I need you to search through the field that is data of type date. How can I do it? My search formula is the following:

SortByColumns (Search ([@ App_Horas]; TextSearchBox1.Text; "Comment"; "User"); "Comment"; If (SortDescending1; Descending; Ascending))

[gabibalaban · Accepted solution]

Hi @Labraham36 ,

Use a DatePicker control to select the date you want and on Gallery -> Items use:

SortByColumns (Filter ([@ App_Horas]; DateColumn = DatePickerControl.SelectedDate); "Comment"; If (SortDescending1; Descending; Ascending))

Hope it helps !

[Labraham36]

Thanks friend for the answer! I try but it is not working. What value should I enter in "DateColumn"? Sorry but I'm new and I'm a bit lost. Thanks!

[Labraham36]

I almost got it to work but it gives an error in the equal sign, why could it be?

[Drrickryp]

Datepicker3.SelectedDate