Stuck with this one…
Imagine I have two tables:
- Has just a single row, with multiple columns
- One of those columns is a date (update: it’s actually an if-then-else column, operating on date columns. An important point I initially overlooked…)
- Has multiple rows, and multiple columns
- One of those columns is a date
What I want to do is use the Table A date column in Table B, in an if-then-else column to compare it to the dates in Table B. Problem is, when I bring it in as either a Single Value or Lookup via a (single) relation, Glide no longer thinks it’s a date, so I can’t do date-type comparisons (after, before, etc).
Anyone have an idea how I can work around that?
… actually it just occurred to me that I can probably convert all the dates in both tables to integers, and then do a direct numerical comparison - but that feels really clunky