Action not working because of different date formats

[braganca]

I have both Google Sheets and Appsheet Locale - English UK.

However, there is an action that is not working, and the problem seems to be related with the date format.

I have an action on a table, referring to an action on another table, based on a filter.

The reference action "Pago" is just setting up the value of a YES/NO column to YES, so nothing complicated.

And this is the filter I have in Reference Rows

And the result of this filter, is exactly what I want

However, the action does not run for this row, and the only thing that I notice is the date format. First it apears as 06/05/2024, but below apears as 05/06/2024.

Everthing else seems to be fine, so I believe the date is impeding the action to run on that row. 

Any tips?

[Gustavo_Eduardo]

Se não funcionar exatamente do jeito que você deseja, você pode tentar criar um snap. Por exemplo,

CONCATENATE(

DAY([Date]),

MONTH([Date]),

YEAR([Date])

)

[Steve]

The raw value of a Date column will always be in MM/DD/YYYY format. Expression use the raw format. As @Gustavo_Eduardo indicates, use the DAY(), MONTH(), and YEAR() to extract the components of the date in expressions.

[Gustavo_Eduardo]

It's always good to learn something new, thanks for the clarification on the raw value. @Steve 

[braganca]

Problem is that the result is a list, sometimes just one date, sometimes more. Therefore this wouldn't work. because I never know how many results there will be. 

I tried this

but it's not working either. 

Is there any way on APPSHEET that I can see the whole process running and perhaps understand where is not working. Because like I said, everything else seems to be fine, just the date not matching, but there could be something else that I'm missing.