Case insensitivity

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’)))

0 4 548
4 REPLIES 4
Top Labels in this Space