I have a table k with Date and
table j with date column
now I cant filter rows due to case insensitivity.
action on j table:
SELECT(k[Date], DATE([Date])=DATE([date]))
Note, this expression could significantly impact sync time. The list of values of column ‘Date’ …from rows of table ‘K’ …where this condition is true: ((DATE( …The value of column ‘Date’)) is equal to (DATE( …The value of column ‘Date’)))
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |