If I have a table with a column formatted as date and use the following formula:
[Table 1].Lookup(Date, thisRow.RowId()) I get an error: “Cannot convert value to the specified format”. However if the column is formatted as a number then I get the expected behaviour.
Just to point out that the columns are formatted correctly to accept the date. Here is what I get. The error is in Column 5. Column 2 has the same formula and behaves properly:
Anyone encountered this before?