Strange behavior in SELECT () expression

I am locked in something simple:
With this expression:
SELECT (Repairs [Rep Id],[Withdrawn Date]>DATETIME ([Last payment]. [Date]))

  1. If I test the expression with the “Test” button, it correctly returns all Rep Id’s.
  2. In the Form view where I want to show it, you don’t see anything.
  3. If I replace the expression DATETIME ([Last payment]. [Date]) with a written date, it shows the list perfectly.
  4. [Last payment] is a virtual column with the following expression
    MAXROW (“Payments”, “_ RowNumber”), of type Ref, which correctly returns the date of the last payment.

What am I doing wrong?

Additionally, I make another query, how do I locate the inline view of a SELECT expression to modify which columns are displayed?

0 19 1,301
19 REPLIES 19
Top Labels in this Space