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โ)))
Because the column in table k is Date with an uppercase D and in table j itโs date with a lowercase d?
Try this instead:
SELECT(k[Date], DATE([Date])=DATE([_THISROW].[date]))
To my knowledge, there are only two places in all of AppSheet that are case-sensitive: the CONTEXT() function and the FIND() function.
Thank you.
LOOKUP() is also case-sensitive
References are also case-sensitive.
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |