Filter different conditions

[Anonymous]

I´m working in a double filter app, the first one has to filtrate a number from a column on excel and the second one a date also from excel, but this second one throws me an error which is the next:

La operación solicitada no es válida.
Respuesta del servidor: Error de Tabla1: La cláusula de filtro no es válida: no se admite la operación. Actualmente, solo se admiten los valores únicos "eq", "ne", "contains", "startswith" o "endswith" .
clientRequestId: 60ade09f-2be4-4647-9997-3aa2de038c29.

Thats a pic of how im doing my app, thanks for helping...

[rubin_boer]

hi @Anonymous please check if there is any data in your date column, if not add a column to your excel table =TEXT([@YourDateColumn],"dd/mm/yyyy") and make sure the column is a text and not date column.

do the filter using your new colum remember its text now so something like Filter(table1,YourNewColumn = Text(datetimepicker.selecteddate,"dd/mm/yyyy"))

hope this helps

[Anonymous]

Almost!

Theres still a problem in the filter, but at least I created a new column in text format and now I can call my date as a text, but cant convert it into date again to match with my datepicker2.selecteddate

Any idea? Pls

😞

[rubin_boer · Accepted solution]

hi @Anonymous i opted to have the datepicker's value formatted to text Filter(table1,YourNewColumn = Text(datetimepicker.selecteddate,"dd/mm/yyyy")) to allow for that text comparison.  you can also do Filter(table1,DateValue(YourNewColumn,"en-US") = datetimepicker.selecteddate) where your language codes are the same.

[Anonymous]

Sorry for the delay... I opted to left that idea because of that comparision, but I had to use it again, so I saw again your comment and yeah... It was just what I need! Thank you!