whats wrong on sintaxe?
Format Rules: 2 < ( (YEAR(TODAY())) - (YEAR(DATE(AUTOS{DATA}))) )
AUTOS = Other Table / List DATA = Column of AUTOS
i want to get a data of another table called AUTOS, this table is ref like List. I want that returnes me type Date, to calculate.
Have you tried AUTOS[DATA]?
@Halyne_Ribeiro I think you’ll need to rethink your approach. AUTOS[DATA] will return a list of values, but the DATE(…) function expects a single value.
If the format rule is being applied to the AUTOS table, then you can do something like this:
2 < YEAR(TODAY()) - YEAR([DATA])
The difference between what you wrote and what I wrote: - I removed unnecessary parentheses - I replace AUTOS{DATA} with [DATA]. Format rules are applied one row at a time, so [DATA] will refer to the DATA column of the current row. - I removed DATE(…). If your DATA column is of type DateTime or Date, you won’t need to use the DATE(…) function.
Can you give that a try?
Yes… I tried many differents
YEAR [DATA] works if this column were in the same table, but this data comes from another table. I’ve tried it anyway.
@Halyne_Ribeiro You’re going to need to figure out a way to pick a single value of DATA. You have an entire column of [DATA] values, which one is the right one?
help.appsheet.com - References Between Tables References Between Tables help.appsheet.com
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |