Issue on date format rules

AppSheet AppSheet Q&A
1

Hi

I have this format rule

[Scadenza] < TODAY()

if valid the field should be in red

but with the same value I get some lines in red and someone not

see image here

Max_Luise_0-1721051381361.png
Max_Luise_0-1721051381361.png192×608 15.1 KB

the cells on original sheet are all with same format and value 29/12/2024

can anyone help me ?

thanks!

2

With a format rule of [Scadenza] < TODAY(), shouldn’t all the values in the screenshot above NOT be red, since they are all greater than today?

Do you have any other format rules that are acting on the [Scadenza] column?

3

Is the column type set properly in your data source? Like.. is it set as a Date?

4

Yes

5

I change approach

testing another field

Max_Luise_0-1721123367593.png
Max_Luise_0-1721123367593.png269×108 4.87 KB

I expected to have in red only lines with value = “Scaduto” on field “Scadenza”

but instead I get this (red also in lines with value = “Valido”)

Max_Luise_1-1721123452933.png
Max_Luise_1-1721123452933.png647×255 20.3 KB

so the issue seems not related to date

thanks again for your help

6

How about those other format rules @lynchk21 proposed?