if query condition

[max1010]

Good morning I ask you for help ...
I have this query in an action of a bot, the test is ok but
on the table it always writes TODAY()-1 always enters the first condition.
Because?

IF(
  ISBLANK(
    ANY(
      SELECT(
        APPUNTAMENTI AUTO[DATAAPPUNTAMENTO] ,
       [IDCANE] = [_THISROW].[IDCANE]
     )
  )
), TODAY() - 1,
  ANY(
    SELECT(
      APPUNTAMENTI AUTO[DATAAPPUNTAMENTO] ,
        [IDCANE] = [_THISROW].[IDCANE]
    )
  ) - 1
)

thank you

[1minManager]

Could be many things.  Start off by sending a screenshot of the column types you have set in the APPUNTAMENTI AUTO table

[max1010]

I understand and thank you.

[max1010]

add bot

[max1010]

i also tried with LOOKUP

IF(
ISBLANK(
LOOKUP(
[_THISROW].[IDCANE],
"APPUNTAMENTI AUTO",
"IDCANE",
"DATAAPPUNTAMENTO"
)
),
TODAY() - 1,
LOOKUP(
[_THISROW].[IDCANE],
"APPUNTAMENTI AUTO",
"IDCANE",
"DATAAPPUNTAMENTO"
) - 1
)

[max1010]

this is the test and it is ok but when he writes on the google sheet it always enters the first condition